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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Platform: Report Platform |
Control: Report Server |
Published Date: May 22, 2016 |
Last Revised Date: May 22, 2016

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.

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon