In IIS, if we let the Dashboard Server application run under the local System account, the server is not able to access the remote SQL Server database or SSAS cube. If we change the identity to be under a specific account created for accessing the database, the database access works. This article describes the steps to set IIS identity for accessing remote database from the Dashboard Server which is running under LocalSystem identity.
1. Add a new application pool by clicking Add Application Pool… hyperlink link from the Actions pane on the right side of the IIS (Refer to Figure 1).
Figure 1 - Adding Application Pool
2. Enter the application pool name and select .Net version 4.0 or above, and then set Managed pipeline mode as Integrated in the Add Application Pool window. (Refer to Figure 2). Now, add the application pool by clicking Ok button.
Figure 2 - Add Application Pool window
3. Newly created application pool is listed in the Application Pools section (Refer to Figure 3).
Figure 3 - Application Pools list with newly added pool
4. To change the IIS identity, select the newly created application pool and click Advanced Settings hyperlink from the Action pane (Refer to Figure 4).
Figure 4 – Selecting Application Pool Advanced Settings
5. Change the identity by selecting Identity under the Process Model group in Advanced settings window (Refer to Figure 5).
Figure 5 - Advanced Settings Window
6. Select custom account in the Application Pool Identity dialog and click the Set button. It prompts popup for the custom user credentials. Click Ok after providing the correct credentials that should have permission to access the remote SQL Server database in the Set Credentials dialog. Then, click Ok in the Application Pool Identity. Now, custom user identity is set for the newly created application pool. Finally, click Ok in the Advanced Settings dialog to apply the changes (Refer to Figure 6).
Figure 6 - Adding Custom User Account
7. After setting the new application pool, you need to set it for the Dashboard Service application. To change it, expand the Syncfusion Dashboard Server application, and select Dashboard Service that is shown in the Connections pane on the left side of the IIS. After selecting it, click Advanced Setting hyperlink link on the Actions pane (Refer to Figure 7).
Figure 7 - Selecting Application Advanced Settings
8. In the Advanced Settings dialog, select Application Pool under the General category, and it opens the Select Application Pool dialog. In that, select the newly created application pool and then click Ok to apply settings (Refer to Figure 8).
Figure 8 - Selecting Application Pool
9. After applying all the settings, restart the IIS for correct application of the setting. To restart the IIS, select the host system name that is at the top of the Connections pane and click Restart hyperlink on the Actions pane (Refer to Figure 9).
Figure 9 - Restarting IIS
This page will automatically be redirected to the sign-in page in 10 seconds.