Share via

Can SSRS Reports Application and SSRS Reports DB on a separate Servers?

Ravishanker Maduri 1 Reputation point
2022-01-03T20:34:23.96+00:00

Can SSRS Reports and SSRS DB on a separate Servers?

i,e SSRS Report Server URL will be different and SSRS Reporting Databases on a separate SQL Server ?

162021-image.png

Reason :

We want to reduce the Load on the Database Server , as we have some other Databases also there in the Database SQL Server.

Is it Possible , if so , please share some Documentation Links for the same.

thank you

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,651 Reputation points
    2022-01-04T03:47:07.18+00:00

    Hi @Ravishanker Maduri ，

    SSRS Report Server URL will be different and SSRS Reporting Databases on a separate SQL Server ?

    Do you mean installing the report server and report server database on different machines?
    Yes, it is completely achievable. SQL Server is used to host the report server databases. The SQL Server Database Engine instance can be local or remote.
    If you create the report server database on a remote computer, configure the connection to use a domain user account or a service account that has network access. If you use a remote SQL Server instance, consider which credentials the report server should use to connect to the instance. For more information, see Configure a Report Server Database Connection (Report Server Configuration Manager).
    The report server and the SQL Server instance hosting the report server database can be in different domains. For internet deployment, it's common practice to use a server that's behind a firewall.

    If you configure a report server for internet access, use SQL Server credentials to connect to the instance of SQL Server that's behind the firewall. Secure the connection by using IPSEC.

    There is no need to have an available SQL Server database engine when installing the report server. The server must be available after installation to configure Reporting Services. So you need to configure the report server for remote management. For more information, please refer to: Configure a Report Server for Remote Administration.

    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments
  2. Martin Cairney 2,276 Reputation points
    2022-01-03T22:58:40.997+00:00

    Yes you can.

    You normally initially install SSRS with files only, then install SQL Server separately and create the SSRS databases on the SQL Server then configure the SSRS instance to connect to the SQL Server.

    Some details are [here][1]

    With an existing database, I would suggest taking a backup and restoring it to the remote SQL Server, then reconfiguring SSRS to connect to the remote SQL Server to ensure you don't lose your report details.

    The data sources for the reports can of course be anywhere.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.