Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Licensing and Scaling up SQL Server BI

Licensing and Scaling up SQL Server BI

  • Comments 5
  • Likes

Both Standard and Enterprise editions of SQL Server come with a lot more than just a database engine, there’s also a suite of BI tools:

  • Integration Services (SSIS)
  • Reporting Services (SSRS)
  • Analysis Services (SSAS)

which you are also licensed to use on the same server as the database engine.  That might be OK for a small business, however many of the BI projects I have worked on have needed individual servers for some of these components, and then things get more complicated. 

Essentially if you put a server component of SQL Server (as distinct from the client tools which I’ll come back to) then you must license that server as well.  e.g. you might have Server A with the database engine on and all your databases, while Server B might have Reporting and Analysis Services on and both of these must have an appropriate license of SQL Server.

Which edition is up to you, so your server running database engine might be Enterprise edition, while you might only need Standard edition for your reporting services server.

When it comes to the licensing model you want again each server can be different so Integration Services might only need a 5 CAL license because it isn’t accessed by anyone, but reporting services is opened up to the internet and so must have CPU licensing.

Finally the client tools are not licensed themselves and this includes the client connectivity tools, BI Development Studio, SQL Server Management Studio and the Report Builder, so you can deploy those as needed.

For more information on this complex topic:

Comments
  • According to http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx:

    Q.  Do I need a separate license to run the SQL Server tools and analysis services?

    A.  No, a separate license is not required. However, any device that has SQL Server tools or technologies installed must have a valid SQL Server license.

  • yep so if the server is liccensed through CAL or as a CPU license you don't need a CAL license for the client tools especially. My point is that once you are licesned to access SQL Server you don't need any additional license for the client tools.  

    Andrew

  • I'm confused.

    Stated above, "Essentially if you put a server component of SQL Server (as distinct from the client tools which I’ll come back to) then you must license that server as well.  e.g. you might have Server A with the database engine on and all your databases, while Server B might have Reporting and Analysis Services on and both of these must have an appropriate license of SQL Server." - According to this, to install Integration Services separate from SQL Server, on a different PC, requires an additional server license (not a CAL.)

    Then, also stated above, "Finally the client tools are not licensed themselves and this includes the client connectivity tools, BI Development Studio, SQL Server Management Studio and the Report Builder, so you can deploy those as needed." - According to this, I can put BI Development Studio - which builds and runs Integration Services projects - on any PC, free of charge.

    I'm wanting to set up a PC, with no SQL Server installed on that PC, to develop and run Integration Services packages as regularly scheduled tasks, against SQL Servers on other PC's. I'm hoping all I need is a CAL, for accessing the SQL Servers. I'm hoping I don't need a full-blown SQL Server license. What type of license do I actually need?

    Thanks,

    Randy

  • Randy your last paragraph is correct as it's the services that are licensed, not the tools to access them, so can design integration services packages, reports, cubes etc. in the BI Design studio providing as you say you have a CAL or the SQL server your deploying your BI stuff to is CPU licensed.

    Happy to take this off line (afryer@microsoft.com) if need more help

    Andrew

  • I want to confirm which is correct?

    "to install Integration Services separate from SQL Server, on a different PC, requires an additional server license (not a CAL.)"

    or

    "to install Integration Services separate from SQL Server, on a different PC, is free of charge"

    Thanks.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment