Post reply

Do we need to buy licences in order to give cube access to the users

  • January 4, 2012 at 5:07 am

    #254284

    Dear Experts

    Just a quick question in regards to the cube access?

    Do we need to buy sql server licences for the users who wants to access cubes through excel?

    I have created SSAS cube in our company. In order to give access to other users so they all can access cubes which i have created via excel i have created Roles

    and i have include 10 users in that role. Everyone can access it now it works perfectly fine but my manager seems to think that we needs to buy more licences of SQL server

    and i am saying we don’t need to buy any licences ?

    Let me if you don’t agree with me.

    Your quick response will be much appreciated.

    Thanks,

    Amit

  • January 4, 2012 at 6:13 am

    #1428245

    guys,

    Is there anyone who can answer my query ?

    Please respond.

    Thanks,

    Amit

  • January 4, 2012 at 6:37 am

    #1428255

    What license do you have?

    http://qa.sqlservercentral.com/blogs/pearlknows/2011/01/24/microsoft-sql-server-licensing-for-dummies/[/url]

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • January 4, 2012 at 6:41 am

    #1428258

    on the server which i have used to deploy cube we have Standard Edition of sql server installed but we have another server but we also have another server which i can use where we have Enterprise Edition installed.

    Let me know if we have to buy licences ?

    Thanks for your help.

  • January 4, 2012 at 6:46 am

    #1428262

    andyman123456 (1/4/2012)

    on the server which i have used to deploy cube we have Standard Edition of sql server installed but we have another server but we also have another server which i can use where we have Enterprise Edition installed.

    Let me know if we have to buy licences ?

    Thanks for your help.

    Read through these: -

    Link 1[/url]

    Link 2[/url]

    Link 3

    Realistically, without knowing your set-up anything you're told over the internet is going to be at best a guess.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • January 4, 2012 at 6:55 am

    #1428267

    Sounds to me like your manager is talking about CALs (Client Access Licences)

  • January 4, 2012 at 6:57 am

    #1428268

    i think u did not understand my question. I just want to know if users in our company wants to access SSAS Cubes via excel. Do we need to buy licences for them. At the moment i have created roles in the cubes and have given them access and it works perfectly fine but my manager seems to think we need to buy licences for our users but i disagree.

    Could you please provide your feedback if you know the answer ?

    thanks,

    amit

  • January 4, 2012 at 7:01 am

    #1428272

    do we need to buy client access licences just to access cubes via excel ?

  • January 4, 2012 at 7:30 am

    #1428299

    andyman123456 (1/4/2012)

    do we need to buy client access licences just to access cubes via excel ?

    That depends on how you're licensing SQL Server. Read the links I provided.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply