Integrated authentication configuration method for SQL Server and IIS7

In IIS7, there are more integration verification steps for configuring SQL Server, and the following steps are listed to facilitate learning.

First, you need to confirm the application pool that your Web site uses. Open the Basic Settings dialog box for your Web site. Check the application pool configuration parameters.

Then, in the application pool, locate the corresponding application pool and select Advanced Configuration.

In the identification, select the Network Service Newworkservice.

Now, back to SQL Server, in security, login name, add a new login.

Clicking on the search will eject the Select User or Group dialog box.

Click on the Advanced button in the lower left corner.

Direct click to find immediately.

Locate the network Service user in the listed users, and select and determine.

Once again, go back to the new login interface and there are already network users in the login name.

Click the user mapping on the left to configure access to the database tutorial for the user.

This is configured as the db_owner role to guarantee permissions.