Forum Discussion

pabeader's avatar
pabeader
Icon for Post Patron rankPost Patron
5 years ago

How to segment report server applications on different servers.

I have read in the documenation, that it is possible to segment report server applications onto different servers.  I can't seem to find the documentation that explains HOW to do this. Has anyone do...
Help
pabeader's avatar
pabeader
Icon for Post Patron rankPost Patron
5 years ago

It in this article:

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

 

Under:

A scale-out deployment is used in the following scenarios:

 

  • To segment report server applications on different computers, by using one server for interactive report processing and a second server for scheduled report processing. In this scenario, each server instance processes different types of requests for the same report server content stored in the shared report server database.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

Ok, so that is related to the first link I posted and you can change those settings using the various properties in the second link I posted with the exception that you cannot turn off the interactive report processing anymore, that property has been depricated for some reason

 

see:

 

IsReportManagerEnabled This setting has been deprecated as of SQL Server 2016 Reporting Services Cumulative Update 2. The web portal will always be enabled.