2008r2 licensing

Question

Hey I need to know the licensing requirement for my infrastructure  

I've SQL 2008 R2 Enterprise Edition sitting on Windows 2008r2  Vistrual Box

I have a 2008 SSAS cube which users access the report in excel through SharePoint 2012

Sso i need to know do i need to have a CAL for each user who access the SSAS cube.

I already have 3 developer license so we can develop on SQL 2008r2

Many thanks

Answer 1

You probably mean SharePoint 2010.

You need licence for every user accessing the SQL Server. Check more at: Client Access Licenses and Management Licenses

Answer 2

Hi Rookie_ssis,

Since the question is a license issue, you can call 1-800-426-9400 begin_of_the_skype_highlighting 1-800-426-9400 end_of_the_skype_highlighting, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. You can also visit the following site for more information and support on licensing issues: http://www.microsoft.com/licensing/mplahome.mspx.

---

Regards, Amber zhang

Answer 3

Hi Rooki,

It really depends,

If your SharePoint site is web facing then I suggest you to purchase Per Processor other wise count number of user and devices accessing your cube using SharePoint and then purchase that many CALs. For example if you have 10 users then 10 CAL are required.

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 4

rookie_sis

If the reports in excel are static reports, that is they are placed on SharePoint and are not automatically refreshed when they are accessed by users, then the user's won't need CALs, since delivery of SQL data to the user is not triggered when they open the spreadsheet. If, however, the Excel spreadsheets are linked to the cube, and opening or changing anything in excel results in a call back to SharePoint to refresh the data, every user who accesses the spreadsheet will need to have a SQL CAL. You could go with per proc licensing, but a) you may not be able to buy this product per proc anymore--it would be per core (although you're probably fine if it's on a virtual machine with 4 or fewer virtual procs) and b) Server CAL may be cheaper if you have fewer than 130 users accessing the SQL data. If they already have SQL CALs, to access other sql servers, they don't need any additional licenses. 

Make sure that you get a commercial license for your SQL Server instance. You can develop the infrastructure on MSDN but you can't put that into production.

---

Paul DeGroot Principal Consultant Pica Communications "Solving the Microsoft Licensing Puzzle"