We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases. We also have two sharepoint servers (2010 Enterprise). One in the DMZ hosting the Extranet Web App and the other in our local domain hosting the intranet web aplpication.

  1. It makes sense to install SSRS on Sharepoint Server hosting the extranet for security purposes, although I have it installed on the SQl box with a native sharepoint installation to support integrated mode.
  2. On the other hand I am guessing I can install SSRS on the SQl box or the Sharepoint Server when it comes to the Intranet web app.

In both cases here is my Question: Is an additional license required if I want to install SSRS on the Sharepoint Box (which I have been told is the recommended practice) instead of the SQL Box?

2 Answers 2


SSRS, to be used in SharePoint Integrated Mode, must be installed on a server that has SharePoint installed and joined to the farm. Obviously this would not be a good idea to install SharePoint on a Database Engine server if you can avoid it.

Install SSRS on your SharePoint server in Integrated mode. Yes, you must license SQL Server (SSRS) on your SharePoint Server, the license is not included with the Database Engine installation.

As always, however, when it comes to Microsoft Licensing... contact Microsoft Licensing.

  • Thanks for posting. I am a little unsure of the licenses we currently hold. But I am going to go ahead and try to install SSRS on the sharepoint box and see what happens. I would use the same setup file as sql2008 but just not check database engine underfeatures right?
    – user7400
    May 4, 2012 at 20:39
  • That is correct, just just select the Reporting Services component. Integrating with SharePoint happens via the Reporting Services configuration tool.
    – user6024
    May 4, 2012 at 20:57
  • I have setup a named instance on my SQl2008 box without reporting services. I am installing sharepoint using least privileges approach(spadmin,spfarm and spsql accts). I use spsql to run the mssqlserver and server agent services on my sql2008 box. Now when I install reporting services on my sharepoint box would I select only the reporting and analysis features (not the database engine) and the shared features? Additionally would I use the same spsql acct to run services here as well?
    – user7400
    May 7, 2012 at 13:54
  • Only select Reporting Services and create a new ssrs account (you also may want a SSRS Unattended Execution account).
    – user6024
    May 7, 2012 at 14:31
  • 1
    Install a SQL 2008 SP or SP + CU on your SSRS box if you haven't already.
    – user6024
    May 8, 2012 at 15:34

Please don't do it on SQL server. He has it right: https://sharepoint.stackexchange.com/a/35501/3569

I see too many people install it on SQL server. Install it on its own box or WFE server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.