Solution: user 'nt Authority \ Network service' logon Failure ASP. NET Program

ASP. NETProgramSolution: User 'nt Authority \ Network service' Logon Failed

In the Asp.net application, Windows authentication is used when connecting to the database. "User 'nt Authority \ Network service' logon Failure" may occur. In SQL Server 2005, the most popular solutions are as follows:

1. Open SQL Server Management studio and connect to the server.

2. Open "security", right-click and select "Login Name", and open "New login name ...".

3. In the pop-up "login name-New" dialog box, on the "General" selection page, click "search..." on the right of "login name ..." Button.

4. In the "select user or group" dialog box that appears, click the "advanced" button.

5. A "select user or group" dialog box is displayed, and click "Search now ".

6. Select an item named "Network Service" in the "search result" list below. Click OK ".

7. Click "OK" again to return to the "Logon Name-New" dialog box. Click OK ".

8. Open the ASP. NET application again. OK.

If not, find the login name nt authority \ Network Service, right-click the attribute, and change the default database and user ing in the displayed interface.

In the user ing window, check the database to be accessed, and then select db_ower in the database role member identity.