Geeks With Blogs

News Add to Technorati Favorites
Randy Walker Entrepreneur, VB MVP

After presenting at the Tulsa SQL Server SIG I received the following question:

According to all the blogs if you install SSRS on a web server it still burns up another SQL server license even if you don’t install SQL.  Our production SQL server costs like $30,000 for the enterprise version because it’s on an 8 core box.  The SharePoint server where I am trying to install SSRS also has 8 cores.  For SharePoint you have to install SSRS on the web server or it will not work.  Is there a cheap version of SSRS that won’t cost 30k?

Below was my response:

Attached is a document I found detailed your licensing options.  Initially I thought you would not be able to get around buying an Enterprise license because it is the only version supporting 8 processors (  However, it says “Processor licenses are available in Enterprise, Standard, and Workgroup Editions and offer more simplicity for certain scenarios.”  So, you should only have to purchase a workgroup license for 8 processors.

However, there are specific features of SSRS that are specific to the version licensed.  Such as the Enterprise version only supports Data Driven Subscriptions (you can have data trigger the running of a report), plus others.  I believe e-mail subscriptions are a Standard version feature, which is a must have IMHO.

The real question is going to be if you can talk to the person responsible for purchasing/licensing to figure out how to buy the standard workgroup or standard license, plus the additional licensing for the additional processors.  Don’t forget, I’m betting there isn’t 8 processors, because of the newer multi core processors.  So make sure you verify the number of hard processors.

Technorati Tags:
Posted on Saturday, March 22, 2008 12:45 AM | Back to top

Comments on this post: SQL Server Reporting Services Licensing Info

# re: SQL Server Reporting Services Licensing Info
Requesting Gravatar...
For those who need an inexpensive distribution option for SSRS reports, look at rePORTAL at It is a complete portal and scheduling engine that lets you publish and distribute SQL Server Reporting Services (SSRS) and Crystal reports easily and without any need for coding. Licensing is significantly less expensive as it offers a server license with unlimited users.
Left by IT Manager on Mar 25, 2011 12:29 PM

Your comment:
 (will show your gravatar)

Copyright © Randy Walker | Powered by: