ASP.NET用户登录失败'NT AUTHORITY \\ NETWORK SERVICE' [英] ASP.NET Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

问题描述

我要发布一个asp.net网站的远程服务器上。当我的code尝试连接到数据库中，我得到了问题的标题描述的错误消息。现在，我已经到Microsoft SQL Server Management Studio中的2008 SSE，可以看到登录的列表。 NT AUTHORITY \\ NETWORK SERVICE是有的，但我不知道我需要改变，以允许该用户访问数据库什么设置。我在使用登录凭据服务器的窗口我的web.config文件中使用模拟尝试，但只是带来了同样的错误信息，用我的Windows用户名的网络服务来代替。

I'm trying to publish an asp.net website on a remote server. When my code tries to connect to the database, I get the error message described in the question title. Now, I've gone into the Microsoft SQL Server Management Studio for SSE 2008 and can see the list of logins. NT AUTHORITY\NETWORK SERVICE is there, but I'm not sure what settings I need to change to allow this user to access the database. I've tried using impersonation in my web.config file using the windows login credentials for the server, but that just brings up the same error message, with my windows username instead of NETWORK SERVICE.

我的连接字符串如下：

的connectionString =数据源= MECHTRONICRND \\ SQLEX $ P $干燥综合征;初始目录=C：\\的Inetpub \\ aspnettest \\ App_Data文件\\ FLEETMANAGERDB.MDF';集成安全性=真

connectionString="Data Source=MECHTRONICRND\SQLEXPRESS;Initial Catalog='C:\Inetpub\aspnettest\App_Data\FLEETMANAGERDB.MDF';Integrated Security=True"

任何想法？

感谢

- 阿姆鲁

推荐答案

感谢您的答复。看<一后href=\"http://blog.evonet.com.au/post/Setting-up-SQL-Server-2008-for-an-ASPNET-website-on-IIS-70.aspx\">this教程，我发现了如何让用户对数据库的访问。有一次，我已经让NETWORK SERVICE读写访问数据库，我的网站能正常工作与原来的连接字符串。

Thanks for your replies. After looking at this tutorial, I found out how to allow users access to a database. Once I had allowed NETWORK SERVICE read and write access to the database, my website worked fine with the original connection string.

- 阿姆鲁

这篇关于ASP.NET用户登录失败'NT AUTHORITY \\ NETWORK SERVICE'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！