Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links


This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog


Post Categories

About me

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!

kick it on

Print | posted on Tuesday, February 17, 2009 8:01 AM | Filed Under [ Reporting Services ]



# 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?

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

# re: Reporting Services Licensing

Check this document:

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

# re: Reporting Services Licensing

hat was my understanding as well. We have all of the Reporting Services components installed on our database server which sits behind the firewall. And our web servers call the reporting services web service(on the DB server) to retrieve the reports for the users.I spent a lot of time researching the licensing documentation and was so happy when I found this solution. It would be great if someone from Microsoft could confirm that what we're doing is ok.
3/19/2010 5:26 AM | bonus del casino

# re: Reporting Services Licensing

what about Microsoft SQL Server 2005 Express Edition with Advanced Services?
It said that you can "Run SQL Server Reporting Services reports on local relational data".
If I have production data on the different server (properly licensed) - can i still use Reporting server from SQL Express to report with?
4/6/2010 6:15 AM | Nataly

# re: Reporting Services Licensing

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.

snow boots | snow boots for women | columbia sportswear | columbia sportswear outlet | cheap north face jackets | the north face outlet | mac makeup | cheap makeup
10/19/2010 4:38 AM | furry boots

# re: Reporting Services Licensing

This super video converter for mac is developed by Emicsoft Studio, it is currently the best video converter running under Mac os x, comparied by isqunite, Visualhub and other Video Converter for Mac Free vide under simple video editing function embedded, support Even Thought This video converter for mac is a shareware, it's unregistered
10/26/2010 1:46 AM | hanly

# re: Reporting Services Licensing

CORUM LA CHAUX-DE-FONDS, SWITZERLAND.The cornerstone of Corum watch design is the combination of watchmaking traditions of the 18th century with the cutting-edge technologies and designs of the Large selection Of Genuine Corum watches, Admirals Cup, Bubble, Golden Bridge, Coin watch. Authorized Jeweler with Full Warranty on all Corum Watches. Corum Watch "OCTRON ECOLOGIC" FLUORESCENT BULB; Medium bi-pin base fluorescent bulbs. Bulb type: T8; 1.1" diameter bulbs. Average life 20000 hours. 1000, ECOLOGIC. RV Marine. Add that special something to your boat or recreational vehicle. SYLVANIA RV Marine bulbs fit both needs. ecologic bulbs The Smith machine is a piece of equipment used in weight training. It consists of a barbell that is fixed within steel rails, allowing only vertical Shop Smith Machines and Power Cages at Dick's Sporting Goods for the finest quality products at competitive prices, backed by the best service anywhere. smith machine Why to exfoliate the face? Regular face exfoliation is the best way to keep your skin clear and healthy looking. Exfoliating is skin treatments where the Get free info on natural exfoliator for skin care and facial exfoliator. Get tips on using natural facial exfoliator and about homemade face exfoliator. face exfoliator Ski Vacations - Packages to over 80 ski resorts worldwide. Customize your ski vacation to include accommodations Lodging, lift tickets, air travel, A complete guide to the best ski resorts worldwide, the best ski gear, how to's, and much more at SKI magazine. ski
12/24/2010 11:20 PM | nrerr

# re: Reporting Services Licensing

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.
12/30/2010 1:50 PM | IT manager

# re: Reporting Services Licensing

Nice I'm currently working a new SQL project for our fähren kreuzfahrten site and had some issues with the reporting services. As soon as I have fixed that I hope that the fähren kreuzfahrt site will be back up again cause we got a lot of customers who need our fähren service. Thanks for the tipps.
4/18/2011 4:13 PM | Daniel

# re: Reporting Services Licensing

Database technology is super important. Without it I would not be able to store the info that I do for the Indianapolis Jiu Jitsu academy I love training at so much. I'll keep coming to this blog for any of my SQL questions.
1/25/2012 11:50 AM | Scotty2
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET