有一个项目，我只是将它部署在IIS上，（数据库是还原过来的）
Server Error in '/' Application.
--------------------------------------------------------------------------------
用户 'NT AUTHORITY\NETWORK SERVICE' 登录失败。
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 用户 'NT AUTHORITY\NETWORK SERVICE' 登录失败。
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
------解决方案--------------------------------------------------------
1.打开SQL Server Manegement Studio
2.在 安全性 - 登录名 中 添加 NETWORK SERVICE
3.双击该用户 在服务器角色 中 勾选 sysadmin
OK 问题解决
你也可以根据自己的需要任意给用户NETWORK SERVICE授予相应的权限
如果是SQL 2000可以看下这个：http://blog.csdn.net/net_lover/archive/2008/05/11/2431833.aspx
引用自：http://www.yongfa365.com/item/SQL2005-NT-AUTHORITY-NETWORK-SERVICE-Login-Failed