Single-user installation

To add the application pool user to the SQL Server logins (for single-user installation)

1. Start SQL Server Management Studio and create a new login in the Security section.

2. For the login name type IIS APPPOOL\<Application Pool Name>. The application pool that we used for this document is AssetStrategyOptimization, hence the login name as shown in the image below.
   

   Note: You will have to type the name for the application pool and -user. SQL Server Management Studio may not find it if you use the Search button

3. In the Select a page pane choose User Mapping. Select the Asset Strategy Optimization Database in the User mapped to this login pane and check the DB_OWNER in the Database role membership pane.

   
   

4. Click the OK button to close the dialog

5. Create another new login using the login name for the user that you used as the user to connect to the Website and the Web Application. Map this user to the same database as specified in the step 3.

6. Map the database users to the local users list via Windows Local Users and Groups. For more information on adding users, refer to the Microsoft documentation.