Error
=================
login failed for user nt authority\network service
Solution
==========
To manually set the permission for NT AUTHORITY\NETWORK SERVICE, follow these steps:1.
Click Start, click Run,
type %systemroot%\Help\iisHelp, and then click OK.
2. Right-click the Common folder, and then click Sharing and Security.
3. On the Security tab, click Add, type NETWORK SERVICE, and then click OK.
4. Click NETWORK SERVICE, click to select the following check boxes under Allow, and then click OK: • Read and Execute
• List Folder Contents
• Read
5. Click Start, click Run,
type %systemroot%\system32\inetsrv, and then click OK.
6. Right-click the ASP Compiled Templates folder, and then click Sharing and Security.
7. On the Security tab, click Add, type NETWORK SERVICE, and then click OK.
8. Click NETWORK SERVICE, click to select the Full Control check box under Allow, and then click OK
9. Click Start, click Run,
type %systemroot%, and then click OK.
10. Right-click the IIS Temporary Compressed folder, and then click Sharing and Security.
11. On the Security tab, click Add, type NETWORK SERVICE, and then click OK.
12. Click NETWORK SERVICE, click to select the Full Control check box under Allow, and then click OK
After you have completed these steps, restart the IIS Admin Service. To do this, follow these steps:
1. Click Start, click Run,
type Services.msc, and then click OK.
2. Right-click IIS Admin, and then click Restart.
exec sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'
EXEC sp_grantdbaccess N'NT AUTHORITY\NETWORK SERVICE'
