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

问题描述

我试图在远程服务器上发布asp.net网站。当我的代码尝试连接到数据库时，我得到问题标题中描述的错误消息。现在，我进入了Microsoft SQL Server Management Studio for SSE 2008，可以看到登录列表。 NT AUTHORITY\NETWORK SERVICE是存在的，但我不确定需要更改哪些设置以允许此用户访问数据库。我试过在我的web.config文件中使用模拟服务器的Windows登录凭据，但只是带来了相同的错误消息，用我的Windows用户名而不是NETWORK服务。

我的连接字符串如下：

connectionString =Data Source = MECHTRONICRND\SQLEXPRESS; Initial Catalog ='C：\Inetpub\aspnettest \App_Data\FLEETMANAGERDB.MDF';整合安全性= True

任何想法？

/ p>

- Amr

解决方案

感谢您的回复。查看本教程，我发现如何允许用户访问数据库。一旦我允许NETWORK SERVICE对数据库进行读写访问，我的网站就可以使用原来的连接字符串。

- Amr

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.

My connection string is as follows:

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

Any ideas?

Thanks

--Amr

解决方案

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.

--Amr

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