How to add permission for IIS Application pool to access SQL Server in Windows Authentication mode?
We use LocalSystem as the Identity to in IIS to run as built-in account by default.
If this LocalSystem account does not have access to the SQL Server database that you have chosen in the startup of the Report Server, then you will need to change this application pool setting in IIS to set the account which has access to the database.
Please follow the below steps to do this.
Step 1: Open IIS à Application Pool and select SyncfusionReportServer.
Step 2: Right click on “SyncfusionReportServer” and select “Advanced Settings”.
Step 3: Choose “Options” in the “Identity” under “Process Model”.
Step 4: Choose “Custom Account” and select “Set” to set the account that has access to the SQL Server database.
Step 5: Type the “User name” and “Password” and click on “OK”.
Now the Report Server application will have access to its database using this account.
This page will automatically be redirected to the sign-in page in 10 seconds.