We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to add permission for IIS Application pool to access SQL Server Database ?

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.

Article ID: Published Date: Last Revised Date: Platform: Control:
6898 05/22/2016 05/22/2016 Report Platform Report Server
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.