February 23, 2012 at 10:52 am
I have Reporting Server and Analysis Server running on an existing database server that contains existing reports. I would like to install Reporting Server on a different stand alone server, but utilize the existing SSRS database on the database server. So, I guess my question is, can I have two reporting servers using the same SSRS database?
February 23, 2012 at 11:11 am
It seems you are looking for a scale out deployment.
Here is some info and references.
http://technet.microsoft.com/en-us/library/ms156453.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2012 at 11:22 am
Excellent! Thank you.
February 23, 2012 at 1:00 pm
You are welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2012 at 1:14 pm
Yup, that turned out to be exactly what I was looking for. Worked like a dream.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply