Configuring Reporting Services for Critical Manufacturing#

To configure reporting services for Critical Manufacturing in Always On on Availability Groups you need to create the database in its own availability group. Please refer to this ⧉ Microsoft article for instructions on how to configure reporting server on that scenario.

The following changes should be performed on ReportServer.Config.

Authentication#

Warning

Basic authentication is a requirement for container-based installations. For more information on how to enable basic authentication, visit https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver16 ⧉. The host is able to use basic authentication but it must be manually enabled. Otherwise, it should be configured in ReportServer.Config:

<AuthenticationTypes>
    <RSWindowsNTLM/>
    <RSWindowsBasic/>
</AuthenticationTypes>

Concurrent Connections#

By default Microsoft Reporting Services have the maximum number of requests per user set to 20. Given the nature of our system we recommend this limit to be increased to maximum number of users seeing reports simultaneously. If in doubt, increase it to at least 500.

<Add Key="MaxActiveReqForOneUser" Value="500" />