Hello experts,
I have a request to install SQL Server Reporting Services. I plan to use SSRS 2017. My question is - We have another SSRS 2017 instance that uses a remote ReportServer db on one of our shared SQL Servers.
Can I use that same remote ReportServer db as the remote SSRS db for the new SSRS 2017 instance that I am about to install? If so, will the content for each instance be properly separated so that clients don't see each other's reports?
I could also install a SQL Server instance on the new host itself, but I'd rather not create a new SQL instance if I can avoid it.
Thanks for any help.
-- 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
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply