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

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

2 Answers 2


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.

  • Thanks, the RS Configuration Manager after installing was the key.
    – RyanW
    Commented Aug 19, 2013 at 23:38

Indeed they can! What you're looking for is called a Scale Out Deployment. I've not done it myself, but from what I understand, it's pretty straightforward.

Details on the process here on technet.

  • Actually, I don't want scale out, I want entirely different SSRS instances, with database and all. They would serve different reports entirely. A scale out would server the same reports on 2 different web servers. Make sense?
    – RyanW
    Commented Aug 14, 2013 at 18:35
  • 1
    Okay, so do you mean that you want 2 different sets of ReportServer/TempDB databases set up on the same SQL server (machine 1)? That should be fine I think, as long as you give the 2 SSRS installations different instance names (by choosing named instance during setup), I think the Report ServerDB/TempDB can be anywhere you want. When you install a named instance, it becomes part of the DB name. For example, I have one at work that is: ReportServer$LIVE/ReportServer$LIVETempDB. Looking at @RLF's answer, I think they've actually covered this there. Commented Aug 14, 2013 at 22:02

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.