Forum Discussion

senthil_kumar's avatar
senthil_kumar
Copper Contributor
Jan 06, 2025

Authentication error when refreshing SSRS 2019 report

We are encountering authentication issue when refreshing the report in SSRS web portal.

Report Server is configured to run using Virtual Service Account. In the RSReportServer.config file, RSWindowsNTLM authentication type is used.

The report is connecting to the data source (internal product) using custom ADO.NET Data Provider. Data source is configured with "As the user viewing the report" credentials. Test connection works.

When the user opens the report for the first time, report opens successfully. In our product log, we see that the connection was made using logged on domain user account. When the user refreshes the report after some time (3 minutes), report fails to load due to authentication error. In our product log, we see that the connection was made using service account (machine account of the SSRS server) and authentication fails because the service (machine) account is not allowed to access our product.

The same configuration works successfully in SSRS 2016. Not sure why the report in SSRS 2019 is connecting to data source using service account instead of logged on domain user account even though it's configured to use the user account viewing the report. I have experimented with RSWindowsNegotiate and EnableAuthPersistence in RSReportServer.config. The issue still exists. Any help/guidance would be appreciated.

No RepliesBe the first to reply

Resources