Your organization may prefer to use Active Directory logins to access SQL Server rather than SQL logins. If so, use the set of database connection strings in the ConnectionStrings.config file that have the parameter
The user that will be used for authentication is the App Pool identity. If you need to change this, take the following steps:
- Open IIS Manager
- Choose the Application Pool
- Click Advanced Settings
- Change the Identity listed. You may need to specify the user name as "Domain\username"
- Restart the App Pool
The application will then use the application pool identity's credentials to try to log in to SQL Server.