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

Question

Post reply

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

andyman123456

SSC-Addicted

Points: 479
More actions
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

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

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

andyman123456 SSC-Addicted Points: 479 More actions · Answer 1

guys,

Is there anyone who can answer my query ?

Please respond.

Thanks,

Amit

Cadavre SSC-Forever Points: 41690 More actions · Answer 2

What license do you have?

http://www.sqlservercentral.com/blogs/pearlknows/2011/01/24/microsoft-sql-server-licensing-for-dummies/%5B/url%5D

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/

andyman123456 SSC-Addicted Points: 479 More actions · Answer 3

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.

Cadavre SSC-Forever Points: 41690 More actions · Answer 4

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/

darkfour Old Hand Points: 383 More actions · Answer 5

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

andyman123456 SSC-Addicted Points: 479 More actions · Answer 6

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

andyman123456 SSC-Addicted Points: 479 More actions · Answer 7

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

Cadavre SSC-Forever Points: 41690 More actions · Answer 8

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/