question

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 asked CharlieLor-4693 answered

How to run reporting services from multiple 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?

sql-server-generalsql-server-reporting-services
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?



0 Votes 0 ·

I mean two Report Server databases for SSRS.

0 Votes 0 ·

That's not possible, on SSRS is link to one ReportServer database.

0 Votes 0 ·
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered ZoeHui-MSFT commented

What's the licenses for running just the SSRS instance on another box?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

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.

94834-hosting-on-remote-site.png

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

94826-reporting-services-error.png

Any suggestion? Thank you.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.