We are encountering authentication issue when refreshing the report in SSRS 2019 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 which supports integrated Windows Authentication. 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 who opened the report. 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 set to false in RSReportServer.config. The issue still exists. Any help/guidance would be appreciated.
