Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Reporting Services Licensing


Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple instances on one server? Virtualizing servers on a single server? It can get very confusing, very quickly.

I’m regularly asked by a former students, clients, and people in the Forums about licensing for a SQL Server Reporting Services instances. A typical question is: How many SQL Server licenses are required when the Report Server is installed on one server and the back end database is installed on a separate remote server?

Here are a couple of links that help describe the SQL Server licensing models.

And by the way, the answer to the sample question? Each server where a Business Intelligence component is installed requires a valid SQL Server license. So, a remote database deployment scenario where the Report Server is installed on one server and the ReportServer database is installed on a separate server requires two licenses of SQL Server.

Reporting Services Licensing

Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple instances on one server? Virtualizing servers on a single server? It can get very confusing, very quickly.

Recently, I was asked by a former student about licensing for a SQL Server Reporting Services instance. In the proposed scenario, the Report Server would be installed on one server and the back end database would be installed on a separate, remote server. How many licenses of SQL Server are required?

In short, each server where a Business Intelligence component is installed requires a valid SQL Server license. So, a remote database deployment scenario where the Report Server is installed on one server and the ReportServer database is installed on a separate server requires two licenses of SQL Server.

But don’t take my word for it. Here are a couple of links that will help clarify licensing requirements.

Special Licensing Considerations for SQL Server 2005

SQL Server 2008 Pricing and Licensing

Cheers and I hope this helps!

Joe
kick it on DotNetKicks.com

Print | posted on Tuesday, February 17, 2009 8:01 AM

<!– –>

Feedback

# re: Reporting Services Licensing

really, as far as I know every server that runs any service of sql server needs separate licensing… And it is very expensive to have at leat 2 physical processor server for your SSRS…

2/17/2009 8:16 AM | Remote DBA

# re: Reporting Services Licensing

I could use a clarification here. Having any SQL Service run on a separate server makes sense that it would require an additional license. However, I’m under the impression that having the web components run on a different server does NOT constitute a SQL Service and therefore would NOT require a separate license.

Am I mistaken there?

Nick

11/10/2009 1:03 PM | Nick L Duckstein

# re: Reporting Services Licensing

Check this document:

http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

It seems like if you want to install reporting services web components (the site and the web service) on a different server where SQL Server 2008 is installed then you will need an other license.

12/17/2009 7:58 AM | Jairo Portela

Post Comment

Title
Name
Email
Url
Comment 
Remember Me?

Enter the code shown above:

Comments

Posted by kevriley on 18 December 2009

One other question I have seen is about the Report Manager.

More specifically if the Report Manager web application is installed on a machine running IIS, pointing at a licensed SSRS instance - does that need a license?  I found an answer for 2005 in the EULA, which states that you don't need a license for Report Manager, but have never found anythinng similar for 2008.  Any ideas?

Posted by Steve Jones on 18 December 2009

My reading is that the report manager would need a license, but you've have to call MS and ask for your specific situation.

Posted by kevriley on 18 December 2009

That was the only conclusion I could come up with too!

Posted by Anonymous on 20 December 2009

Pingback from  Reporting Services Licensing | Webmasters feeds

Posted by Anonymous on 22 May 2010

Pingback from  Sigma Crossfire, Mitsubishi Sigma Replacement Vin D

Posted by Anonymous on 22 May 2010

Pingback from  Parts 2001 Xg300 Catalytic Converter Hyundai Scoupe, Parts Hyundai Scoupe Turbo Oxygen Sensor - 424.myipgirl.com

Posted by Anonymous on 24 May 2010

Pingback from  E 350 Manual Ford Econoline Super Duty, Northern Super F - 201.tijuanareader.com

Posted by Anonymous on 24 May 2010

Pingback from  260z Bulb Electrical 240z 280zx, Buy 260z Napa Datsun 240z - 273.dlmreza.net

Posted by Anonymous on 25 May 2010

Pingback from  Auto Czechoslovakia, Echo Discount Order - 419.luna-atra.net

Posted by Anonymous on 25 May 2010

Pingback from  Walmart Es330, Parts 2006 Lexus Es330 Oxygen Sensor - 18.tvshowzone.com

Posted by Anonymous on 25 May 2010

Pingback from  Cls63 Amg Complementary, Buy G55 Cls63 Amg Mercedes Benz Sl550 - 369.codebluehacks.org

Leave a Comment

Please register or log in to leave a comment.