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.