In order for integrated security to be used to connect to the database, you must set the Application pool to use a domain account to run under.
To make these steps simpler, we will name the domain account VaultDBRunner, please adapt to your requirements.
- Create the VaultDBunner account in the domain;
- Grant access to the SQL Server instance to VaultDBRunner;
- Grant access to the database to VaultDBRunner;
- In IIS Manager, expand the Application pool section and locate the application pool used by your Devolutions Server site. By default it has the same name as the name of the web application;
- In the Advanced Settings, edit the Identity setting to get the VaultDBRunner account.
In some cases the UPN format must be used for the username (firstname.lastname@example.org) instead of the NETBIOS format (domain\username).
- Once the account is set as the application pool identity, you can grant least permissions with the Apply Least Permissions button for the Web Application and the Scheduler Service sections. It is also possible to generate the least permissions SQL queries to run it manually on the SQL Server, see Generate script for database permissions.