You cannot use the same SSRS database for multiple installations of SSRS (unless its a scale out farm)
You can however create multiple SSRS databases
ReportServer
ReportServer_Customer1
ReportServer_Customer2
And then have 3 different SSRS portals all pointing to their corresponding SSRS database
November 4, 2021 at 4:15 pm
Thanks, Ant-Green! That is the info I needed.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 4, 2021 at 4:28 pm
If I understand your question, you want to use the same SQL installation for multiple SSRS installations? If that's true, I have a single SQL server that contains 4 different report server databases, one for each of our non-production environments.
ReportServer$DEV_2014
ReportServer$DEV_2014TempDB
ReportServer$QA_2014
ReportServer$QA_2014TempDB
ReportServer$STG_2014
ReportServer$STG_2014TempDB
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply