Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

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?

share|improve this question

2 Answers

up vote 3 down vote accepted

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.

share|improve this answer
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 '12 at 20:39
That is correct, just just select the Reporting Services component. Integrating with SharePoint happens via the Reporting Services configuration tool. – Trevor Seward May 4 '12 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 '12 at 13:54
Only select Reporting Services and create a new ssrs account (you also may want a SSRS Unattended Execution account). – Trevor Seward May 7 '12 at 14:31
1  
Install a SQL 2008 SP or SP + CU on your SSRS box if you haven't already. – Trevor Seward May 8 '12 at 15:34
show 6 more comments
up vote 0 down vote

Please don't do it on SQL server. He has it right: http://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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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