patternsqlMinor
Possible to run multiple Reporting Services (SSRS) instances on different machines with databases on same machine?
Viewed 0 times
reportingssrssamedatabasesinstanceswithdifferentpossibleservicesmultiple
Problem
With SQL Server 2012, can SSRS instances be setup on two different machines, with both instances using the same machine for their SQL Server databases?
Machine 1
Machine 2
There's this document describing installing multiple instances in 2005, but on the same machine. Can you point me to a better resource for our design? Is this still supported on 2012? How are the SSRS databases (ReportServer, ReportServerTempDB) created for the 2nd instance?
Machine 1
- SQL Server 2012 Database Server
- SSRS instance 1
Machine 2
- SSRS instance 2 pointed to machine 1's database server
There's this document describing installing multiple instances in 2005, but on the same machine. Can you point me to a better resource for our design? Is this still supported on 2012? How are the SSRS databases (ReportServer, ReportServerTempDB) created for the 2nd instance?
Solution
Yes, you can have several Report Servers installed on a single SQL Server. As you noted, the multi-instance support on a single machine is available, but not what you are after.
For multiple distinct ReportServers on different servers, but using a single database, you simply have to configure this in the Reporting Services Configuration Manager.
As noted by GShenanigan this is described in the Scale Out Deployment. http://technet.microsoft.com/en-us/library/ms159114.aspx (same link)
In that phase of installing a Report Server, you must choose the database server that you want to use. Then you can separately use the RS Configuration Manager to either choose the existing ReportServer datbase or choose a new database named to whatever you want to call it.
When a new database is set up, the ReportServerTempDB will be named similarly. For example, creating ReportServerHQ would have a ReportServerHQTempDB also created.
For multiple distinct ReportServers on different servers, but using a single database, you simply have to configure this in the Reporting Services Configuration Manager.
As noted by GShenanigan this is described in the Scale Out Deployment. http://technet.microsoft.com/en-us/library/ms159114.aspx (same link)
In that phase of installing a Report Server, you must choose the database server that you want to use. Then you can separately use the RS Configuration Manager to either choose the existing ReportServer datbase or choose a new database named to whatever you want to call it.
When a new database is set up, the ReportServerTempDB will be named similarly. For example, creating ReportServerHQ would have a ReportServerHQTempDB also created.
Context
StackExchange Database Administrators Q#47882, answer score: 3
Revisions (0)
No revisions yet.