How to solve an error in connecting ASP. NET to SQL Server in IIS

Another way to solve the connection problem is to enable SQL Server Authentication in IIS, and then connect to the string using the user ID and password; or when ASP. NET should
Use the ASP. NET impersonation method when the program runs with another Windows user rather than ASPNET.
To enable the ASPNET account to access the database of ASP. NET applications, follow these steps:

1) start SQL Server Management Studio, specify the name of the SQL Server instance, and log on in Windows Authentication mode.

2) use the grantlogin stored procedure to add Windows users to the SQL Server database. This numerator will assign the ASPNET account connection
Access SQL Server permissions. Note: Replace the MachineName in the command with the Host Name of the local machine.
Exec sp_grantlogin 'machinename \ aspnet'

3) after you grant the SQL Server connection permission to the ASPNET account, you must also grant it the permission to access the database of the ASP. NET application.
Permission. Note: replace DateBaseName with the Database Name of the ASP. NET application:
USE DateBaseName
Exec sp_grantdbaccess 'machinename \ aspnet'

4) Finally, you need to grant the ASPNET permission to access the internal objects of the ASP. NET application database, such as executing the stored procedure, reading and
Modify tables. The simplest way is to assign the db_owner role to the database of an ASP. NET application to the ASPNET account. If the previous steps
You have connected to the database of the ASP. NET application. Enter the following command:
Exec sp_addrolemember 'db _ owner', 'achinename \ aspnet'

Now you can connect to the database in Windows Authentication mode from the Web application.