在ASP.NET中访问SQL server使用了信任连接，该为哪个用户在数据库中赋权

Question

我的SQL SERVER是加载在一台DC上的，现在上面有个ASP.NET的应用，使用了 Trusted_Connection访问SQL SERVER

请问该为哪个用户在数据库中grant访问权限

是 IUSER_XXXXX 还是 NETWORK SERVICE，网上看了很多文章，说什么的都有

谢谢

Answer 1

我的SQL SERVER是加载在一台DC上的，现在上面有个ASP.NET的应用，使用了 Trusted_Connection访问SQL SERVER

请问该为哪个用户在数据库中grant访问权限

是 IUSER_XXXXX 还是 NETWORK SERVICE，网上看了很多文章，说什么的都有

谢谢

再补充一下，貌似本地\network service这个账户在提升了域控制器后就不存在鸟。 我试着把IIS_WPG加进去给了权限，也是行不通的。汗

Answer 2

http://support.microsoft.com/kb/316989

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful.
Visual C++ MVP

Answer 3

http://support.microsoft.com/kb/316989

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful.
Visual C++ MVP

实在对不起，不过这篇文章里的东西并不能解答我的问题。

对ASPNET (IIS 6.0前）和NETWORK SERVICE的授权，我在之前做过很多了。 现在我的问题是我现在是DC，在数据库中为Windows登录授权的时候找不到 NT AUTHORITY\NETWORK SERVICE。

谢谢

Answer 4

http://social.msdn.microsoft.com/Forums/en-US/asmxandxml/thread/201da76e-197e-46dc-bad3-a0ea1a8639af

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful.
Visual C++ MVP