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

KIRUBAKARAN J A 21 Reputation points

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,639 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 27,466 Reputation points


    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.

    The youtube video is also a good tutorial to refer.

    Other related article:

    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.



    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 No comments

  2. KIRUBAKARAN J A 21 Reputation points

    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


    what happen if , same URL for both RS server ?

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