User & #39; nt authority \ network service & #39; Logon Failed ., Authoritynetwork

User 'nt AUTHORITY \ NETWORK service' Login Failed ., Authoritynetwork

Step 1: Add 'nt AUTHORITY \ NETWORK Service' to the Administrator Group
My computer --> right-click --> Manage --> local users and groups
Select "group" --> double-click "Administrators" --> click "add" --> click "advanced" --> click "find now" --> select a Network Service user from the list below --> click "OK" --> join twice.

Step 2 Add a NetWord Service user to the Enterprise Manager
Open SQL Server Enterprise Manager --> select database instance --> open "security" node --> select "login" --> right-click the list on the right --> select "New login "--> on the "General" tab, click the button next to "name"... "--> select" Administrators "group --> click the" members "button below --> select" Network Service "--> click" add "--> click" OK ", return to the "New login" dialog box --> ensure that the authentication type is "windows Authentication" and "Allow access" --> click "OK" --> close "Enterprise Manager"

Step 3
Run the asp.net program again and select windows for the database connection string.

 

 

Open sqlserver Enterprise Manager --> select database instance --> open "security" node --> select "login" --> in the user area on the right, right-click "nt authority \ network service" --> properties --> server role, and choose "system administrators"> "OK" --> close Enterprise Manager in the options below. You can !!!

Logon: "User 'nt AUTHORITY \ NETWORK service' Logon Failed", Microsoft NET Framework Version: 40

I have never encountered any problems that may cause logon failures due to the upgrade of the Framework. Check whether you have installed 4.0 on the server and enabled the 4.0 framework in its service. Then, check whether all of the following steps are in place:
Step 1 (server deployed on the website): Add 'nt AUTHORITY \ NETWORK Service' to the Administrator group.
My computer --> right-click --> Manage --> local users and groups
Select "group" --> double-click "Administrators" --> click "add" --> click "advanced" --> click "find now" --> select a Network Service user from the list below --> click "OK" --> join twice.

Step 2 (Database Server) Add the NetWord Service user to the Enterprise Manager
Open SQL Server Enterprise Manager --> select database instance --> open "security" node --> select "login" --> right-click the list on the right --> select "New login "--> on the "General" tab, click the button next to "name"... "--> select" Administrators "group --> click the" members "button below --> select" Network Service "--> click" add "--> click" OK ", return to the "New login" dialog box --> ensure that the authentication type is "windows Authentication" and "Allow access" --> click "OK" --> close "Enterprise Manager"

Step 3
Run the asp.net program again and select windows for the database connection string.
 
When Microsoft Windows 7 + SQL server2008 uses IIS to publish a local NETWORK system, the system always prompts "User NT AUTHORITY \ NETWORK SERVICE Logon Failed"

Change SQL 2008 logon mode to hybrid logon Mode