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

Question

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?

Answer 1

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

Answer 2

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