In our 2014 SQL Server, we can run two instances of reporting services. However, in SQL Server 2019, it seems we're limited to only one instance. How do I combine two or point Reporting Services to two different reporting databases?
In our 2014 SQL Server, we can run two instances of reporting services. However, in SQL Server 2019, it seems we're limited to only one instance. How do I combine two or point Reporting Services to two different reporting databases?
How do I combine two or point Reporting Services to two different reporting databases?
Do you mean 2 ReportServer databases for SSRS itself or 2 datasource for reporting content?
That's not possible, on SSRS is link to one ReportServer database.
Hi @CharlieLor-4693,
SQL Server Reporting Services are no longer part of the installation media since SQL Server 2017. They are delivered as a separate Installer.
The new Installation Wizard gives no option to install multiple instances of SSRS 2017 on the same machine.
It's hard to combine two Reporting Services to two different reporting databases from SSRS side.
We'd suggest that you may install another SSRS instance in another machine.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
What's the licenses for running just the SSRS instance on another box?
Hi @CharlieLor-4693,
For question regarding licensing please contact a Microsoft sales partner or licensing expert.
Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist.
For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations
Just for testing purposes, I installed ReportingServices standalone on a separate box. Now, I got this error when launching http://rstest/ReportServer
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
Does this mean I can't point the database to another SQL Server that already another ReportServer database?
Does this mean I can't point the database to another SQL Server that already another ReportServer database?
Yes, you can create a SSRS farm; serveral SSRS instances using the same ReportServer database with same content/reports.
So, what does this error means?
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
The Report Server is running SQL Server 2019 Standard Edition. The SSRS instance that's running on the same box as the SQL Server 2019 Standard has no issue. It's this separate box that I have RS installed alone that's showing this error. Does it mean I have to go with Enterprise edition for this "SSRS farm" to work? I want to create two SSRS instances that points to the same SQL Server 2019 instance.
Okay, looks like after I remove the old machine name from the Report Server database and re-connect the remote Report Server database, I'm prompted with this information. In the Service Account, I'm using "Virtual Service Account". In the Report Server Database credential, it's using Service Account for Credential and Login is NT SERVICE\SQLServiceReportingServices.

Once everything is configured, I try to launch the Web Service URL and this is the error I got on the browser.

Any suggestion? Thank you.
14 people are following this question.