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. Image for the cookie policy date
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: Dashboard Platform |
Control: Dashboard Server

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 Dashboard 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 SyncfusionDashboardServer.


Step 2: Right click on “SyncfusionDashboardServer” 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 Dashboard Server application will have access to its database using this account.

You must log in to leave a comment
Mar 04, 2020

Tried other solutions but none worked for me. But this worked like a charm. Thanks

Dhivyabharathi Govindaraj [Syncfusion]
Mar 09, 2020

Hi Sanjeev,

Most Welcome! Please get back to us if you need any further assistance.

Thanks, Dhivya

Please sign in to access our KB

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

Up arrow icon

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

Live Chat Icon For mobile