Do you verify that Report Server authentication settings allow a wide range of web browsers?

Last updated by Tom Bui [SSW] 7 months ago.See history

The default configuration for Report Server isn't accessible by most mobile browsers and some desktop browsers too. You can adjust the authentication types allowed to increase the range.

The configuration file for the Report Server is named RSReportServer.config and the default location is:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\

You should make a backup of the configuration before editing it so you can rollback if you make a mistake.

We normally change the AuthenticationTypes node from:

<AuthenticationTypes>
  <RSWindowsNegotiate /> 
</AuthenticationTypes> 

to:

<AuthenticationTypes>
  <RSWindowsNegotiate /> 
  <RSWindowsKerberos /> 
  <RSWindowsNTLM /> 
</AuthenticationTypes> 

Check out the different Authentication Types in the Report Server documentation and select the types that suit your needs.

More details on configuring Windows authentication on the report server can be found here: Configure Windows Authentication on the Report Server.

We open source. Powered by GitHub