multiple report server point to single report server database sql ssrs 2016

KIRUBAKARAN J A 21 Reputation points
2020-12-11T09:00:42.547+00:00

Two ssrs Server: RSserver1 & RS Server2

One DB server: DBserver1

need to configure RSserver1 & RS Server2 both using same Reportserver Database on DBserver1

( if RSserver1 down then i can use RS Server2 wise versa)

how to do this?

  • Configure Report server in RSserver1 by creating new Reportserver Database in DBserver1
  • Configure Report server in RSserver2 by creating Existing Reportserver Database in DBserver1.
  • Backup encryption key from RSserver1 & Restore it in RSserver2 (in scale-out-deployment)
  • what abt web service URL & web Portal URL . did i need to both servers same?

any setup by step doc there?

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,798 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,586 Reputation points
    2020-12-11T09:35:36.07+00:00

    Hi @KIRUBAKARAN J A ,

    What you're looking for is called a Scale Out Deployment.

    Scale-out deployments consist of:

    1.Two or more report server instances sharing a single report server database.

    2.Optionally, a network load-balanced (NLB) cluster to spread interactive user load across the report server instances.

    Here is the official documentation for your reference.

    https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?redirectedfrom=MSDN&view=sql-server-ver15

    The youtube video is also a good tutorial to refer.

    https://www.youtube.com/watch?v=GT5cMRXWqPk

    Other related article:https://www.sqlshack.com/scaling-out-reporting-services-changes-in-sql-server-2016/

    Please also notice that only Enterprise and Developer SSRS2016 support Scale-out deployment said here.

    Before you configure Scale-out deployment, make sure that you have back up the database and encryption key.

    Both the two different web service URL & web Portal URL could access the same report server.

    If server1 down then we could use server2 web url to access the report server.

    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

    0 comments
  2. KIRUBAKARAN J A 21 Reputation points
    2020-12-11T11:53:10.267+00:00

    hi Zoehui,

    Both the two different web service URL & web Portal URL could access the same report server.

    do i need to configure different URL for both RS server ?

    http://rsserver1/reports -- webportal URL
    http://rsserver1/reportServer -- webservices URL

    http://rsserver2/reports -- webportal URL
    http://rsserver2/reportServer -- webservices URL

    OR

    what happen if , same URL for both RS server ?

    http://ILBIP/reports -- webportal URL
    http://ILBIP/reportServer -- webservices URL