Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

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.

share|improve this answer
    
Thanks, the RS Configuration Manager after installing was the key. –  RyanW Aug 19 '13 at 23:38
add comment

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.

share|improve this answer
    
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 Aug 14 '13 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. –  GShenanigan Aug 14 '13 at 22:02
add comment

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.