用户'NT AUTHORITY \LOCAL SERVICE'登录失败。 [英] Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.

问题描述

想知道是否有人可以提供帮助！


我们登录后立即在内联网系统上收到以下错误..


------------------


异常详细信息：System.Data.SqlClient.SqlException：用户登录失败

''NT AUTHORITY \LOCAL SERVICE''。


源错误：

sql =" SELECT Projects.ProjectID，ProjectName， SessionID FROM Projects，

会话WHERE（Sessions.ProjectID = Projects.ProjectID）和

（Sessions.SessionDate> =''" + theStart +"'' AND Sessions.SessionDate< =''" +

theEnd +"''）ORDER BY Projects.ProjectID DESC" ;;


SqlConnection dbConn =新的
SqlConnection（ConfigurationSettings.AppSettings.Ge t（" System_ConnectionString"））;


dbConn.Open（）;

SqlCommand prjCmd = new SqlCommand（sql，dbConn）;

SqlDataReader prjDr = prjCmd.ExecuteR eader（）;


-----------------


错误发生在" dbConn.Open（）;"线路。


我不知道为什么会突然发生这种情况。这一直很好，

然后突然停了下来。据我所知，服务器上没有任何改变。


详细信息......


..net 2.0

Win2k3服务器

MSDE


Intranet在IIS自己的池中运行。 />

这看起来像是一个安全问题，但是什么？！


任何帮助都非常感谢！


干杯

Dan

Wonder if someone can help!

We''re getting the following error on our Intranet system as soon as we login..

------------------

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
''NT AUTHORITY\LOCAL SERVICE''.

Source Error:
sql = "SELECT Projects.ProjectID, ProjectName, SessionID FROM Projects,
Sessions WHERE (Sessions.ProjectID = Projects.ProjectID) AND
(Sessions.SessionDate >= ''" + theStart + "'' AND Sessions.SessionDate <= ''" +
theEnd + "'') ORDER BY Projects.ProjectID DESC";

SqlConnection dbConn = new
SqlConnection(ConfigurationSettings.AppSettings.Ge t("System_ConnectionString"));

dbConn.Open();
SqlCommand prjCmd= new SqlCommand(sql, dbConn);
SqlDataReader prjDr = prjCmd.ExecuteReader();

-----------------

the error occurs at the "dbConn.Open();" line.

I''ve got no idea why this is suddenly happening. This has been working fine,
and then has suddenly stopped. As far as I''m aware, nothing has changed on
the server.

Details...

..net 2.0
Win2k3 Server
MSDE

the Intranet is running in its own pool in IIS.

It looks like a security issue, but what?!

Any help greatly appreciated!

Cheers
Dan

推荐答案

嗯，错误就是它所说的。 NT AUTHORITY \LOCAL SERVICE没有
登录到SQL Server /数据库。要么给它一个，要么让

应用使用不同的连接字符串和可以访问的凭据。

Peter


-

联合创始人，Eggheadcafe.com开发者门户网站：
http://www.eggheadcafe.com

UnBlog：
http://petesbloggerama.blogspot.com


" musosdev"写道：

Well, the error is exactly what it says. NT AUTHORITY\LOCAL SERVICE doesn''t
have a login to the SQL Server / database. Either give it one, or have the
app use a different connection string with credentials that do have access.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"musosdev" wrote:

想知道是否有人可以提供帮助！

我们登录后立即在内联网系统上收到以下错误。

------------------

异常详细信息：System.Data.SqlClient.SqlException：用户登录失败
''NT AUTHORITY \LOCAL SERVICE''。

来源错误：

sql =" SELECT Projects.ProjectID，ProjectName，SessionID FROM Projects，
Sessions WHERE（Sessions.ProjectID = Projects.ProjectID）AND
（Sessions.SessionDate> =''" + theStart +"''AND Sessions.SessionDate< =''" +
theEnd +"''）ORDER BY Projects.ProjectID DESC" ;;

SqlConnection dbConn = new
SqlConnection（ConfigurationSettings.AppSettings.Ge t（System_ConnectionString））;

dbConn.Open（）;
SqlCommand prjCmd = new SqlCommand（sql，dbConn）;
SqlDataReader prjDr = prjCmd.ExecuteReader（）;

---- - -----------
错误发生在dbConn.Open（）;我不知道为什么会突然发生这种情况。这一直很好，
然后突然停了下来。据我所知，服务器上没有任何变化。

详细信息......

.net 2.0
Win2k3服务器< MSDE

Intranet在IIS自己的池中运行。

这看起来像是一个安全问题，但是什么？！

任何帮助非常感谢！

干杯

Dan

Wonder if someone can help!

We''re getting the following error on our Intranet system as soon as we login..

------------------

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
''NT AUTHORITY\LOCAL SERVICE''.

Source Error:
sql = "SELECT Projects.ProjectID, ProjectName, SessionID FROM Projects,
Sessions WHERE (Sessions.ProjectID = Projects.ProjectID) AND
(Sessions.SessionDate >= ''" + theStart + "'' AND Sessions.SessionDate <= ''" +
theEnd + "'') ORDER BY Projects.ProjectID DESC";

SqlConnection dbConn = new
SqlConnection(ConfigurationSettings.AppSettings.Ge t("System_ConnectionString"));

dbConn.Open();
SqlCommand prjCmd= new SqlCommand(sql, dbConn);
SqlDataReader prjDr = prjCmd.ExecuteReader();

-----------------

the error occurs at the "dbConn.Open();" line.

I''ve got no idea why this is suddenly happening. This has been working fine,
and then has suddenly stopped. As far as I''m aware, nothing has changed on
the server.

Details...

.net 2.0
Win2k3 Server
MSDE

the Intranet is running in its own pool in IIS.

It looks like a security issue, but what?!

Any help greatly appreciated!

Cheers
Dan

嗨彼得


是的，这是有道理的，但是什么是本地服务！？我之前从未听说过

吗？我以为一切都是从\ NETWORK SERVICE完成的？！这是一个错误的假设吗？//


干杯

Dan


" ; Peter Bromberg [C＃MVP]"写道：

Hi Peter

Yeah that makes sense, but WHAT is this LOCAL SERVICE!? I''ve never heard of
it before? I thought everything was done from \NETWORK SERVICE?! Is that a
wrong assumption?!

Cheers
Dan

"Peter Bromberg [C# MVP]" wrote:

嗯，错误正是它所说的。 NT AUTHORITY \LOCAL SERVICE没有登录SQL Server /数据库。要么给它一个，要么让
应用程序使用具有访问权限的凭据的不同连接字符串。
Peter

-
联合创始人，Eggheadcafe。 com开发人员门户网站：
http://www.eggheadcafe.com UnBlog：
http://petesbloggerama.blogspot.com


musosdev写道：

Well, the error is exactly what it says. NT AUTHORITY\LOCAL SERVICE doesn''t
have a login to the SQL Server / database. Either give it one, or have the
app use a different connection string with credentials that do have access.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"musosdev" wrote:

想知道是否有人可以提供帮助！

我们登录后立即在内联网系统上收到以下错误。

------------------

异常详细信息：System.Data.SqlClient.SqlException：用户登录失败
''NT AUTHORITY \LOCAL SERVICE''。

来源错误：

sql =" SELECT Projects.ProjectID，ProjectName，SessionID FROM Projects，
Sessions WHERE（Sessions.ProjectID = Projects.ProjectID）AND
（Sessions.SessionDate> =''" + theStart +"''AND Sessions.SessionDate< =''" +
theEnd +"''）ORDER BY Projects.ProjectID DESC" ;;

SqlConnection dbConn = new
SqlConnection（ConfigurationSettings.AppSettings.Ge t（System_ConnectionString））;

dbConn.Open（）;
SqlCommand prjCmd = new SqlCommand（sql，dbConn）;
SqlDataReader prjDr = prjCmd.ExecuteReader（）;

---- --- ----------

错误发生在dbConn.Open（）;我不知道为什么会突然发生这种情况。这一直很好，
然后突然停了下来。据我所知，服务器上没有任何变化。

详细信息......

.net 2.0
Win2k3服务器< MSDE

Intranet在IIS自己的池中运行。

这看起来像是一个安全问题，但是什么？！

任何帮助非常感谢！

干杯

Dan

Wonder if someone can help!

We''re getting the following error on our Intranet system as soon as we login..

------------------

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
''NT AUTHORITY\LOCAL SERVICE''.

Source Error:
sql = "SELECT Projects.ProjectID, ProjectName, SessionID FROM Projects,
Sessions WHERE (Sessions.ProjectID = Projects.ProjectID) AND
(Sessions.SessionDate >= ''" + theStart + "'' AND Sessions.SessionDate <= ''" +
theEnd + "'') ORDER BY Projects.ProjectID DESC";

SqlConnection dbConn = new
SqlConnection(ConfigurationSettings.AppSettings.Ge t("System_ConnectionString"));

dbConn.Open();
SqlCommand prjCmd= new SqlCommand(sql, dbConn);
SqlDataReader prjDr = prjCmd.ExecuteReader();

-----------------

the error occurs at the "dbConn.Open();" line.

I''ve got no idea why this is suddenly happening. This has been working fine,
and then has suddenly stopped. As far as I''m aware, nothing has changed on
the server.

Details...

.net 2.0
Win2k3 Server
MSDE

the Intranet is running in its own pool in IIS.

It looks like a security issue, but what?!

Any help greatly appreciated!

Cheers
Dan

好的，

让我们去源头阅读吧！

http://msdn2.microsoft.com/en-us/library/ms143504.aspx


Peter

-

联合创始人，Eggheadcafe.com开发者门户网站：
http://www.eggheadcafe.com

UnBlog：
http://petesbloggerama.blogspot.com


& QUOT; musosdev"写道：

OK,
Let''s go to the source and read up on it!

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"musosdev" wrote:

嗨彼得

是的，这是有道理的，但是什么是本地服务！？我以前从未听说过它吗？我以为一切都是从\ NETWORK SERVICE完成的？！这是一个错误的假设吗？！

干杯

Dan

Peter Bromberg [C＃MVP]"写道：

Hi Peter

Yeah that makes sense, but WHAT is this LOCAL SERVICE!? I''ve never heard of
it before? I thought everything was done from \NETWORK SERVICE?! Is that a
wrong assumption?!

Cheers
Dan

"Peter Bromberg [C# MVP]" wrote:

嗯，错误正是它所说的。 NT AUTHORITY \LOCAL SERVICE没有登录SQL Server /数据库。要么给它一个，要么让
应用程序使用具有访问权限的凭据的不同连接字符串。
Peter

-
联合创始人，Eggheadcafe。 com开发人员门户网站：
http://www.eggheadcafe.com UnBlog：
http://petesbloggerama.blogspot.com


musosdev写道：

Well, the error is exactly what it says. NT AUTHORITY\LOCAL SERVICE doesn''t
have a login to the SQL Server / database. Either give it one, or have the
app use a different connection string with credentials that do have access.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"musosdev" wrote:

想知道是否有人可以提供帮助！

我们登录后立即在内联网系统上收到以下错误。

------------------

异常详细信息：System.Data.SqlClient.SqlException：用户登录失败
''NT AUTHORITY \LOCAL SERVICE''。

来源错误：

sql =" SELECT Projects.ProjectID，ProjectName，SessionID FROM Projects，
Sessions WHERE（Sessions.ProjectID = Projects.ProjectID）AND
（Sessions.SessionDate> =''" + theStart +"''AND Sessions.SessionDate< =''" +
theEnd +"''）ORDER BY Projects.ProjectID DESC" ;;

SqlConnection dbConn = new
SqlConnection（ConfigurationSettings.AppSettings.Ge t（System_ConnectionString））;

dbConn.Open（）;
SqlCommand prjCmd = new SqlCommand（sql，dbConn）;
SqlDataReader prjDr = prjCmd.ExecuteReader（）;

---- --- ----------

错误发生在dbConn.Open（）;我不知道为什么会突然发生这种情况。这一直很好，
然后突然停了下来。据我所知，服务器上没有任何变化。

详细信息......

.net 2.0
Win2k3服务器< MSDE

Intranet在IIS自己的池中运行。

这看起来像是一个安全问题，但是什么？！

非常感谢任何帮助！

干杯

Dan

Wonder if someone can help!

We''re getting the following error on our Intranet system as soon as we login..

------------------

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
''NT AUTHORITY\LOCAL SERVICE''.

Source Error:
sql = "SELECT Projects.ProjectID, ProjectName, SessionID FROM Projects,
Sessions WHERE (Sessions.ProjectID = Projects.ProjectID) AND
(Sessions.SessionDate >= ''" + theStart + "'' AND Sessions.SessionDate <= ''" +
theEnd + "'') ORDER BY Projects.ProjectID DESC";

SqlConnection dbConn = new
SqlConnection(ConfigurationSettings.AppSettings.Ge t("System_ConnectionString"));

dbConn.Open();
SqlCommand prjCmd= new SqlCommand(sql, dbConn);
SqlDataReader prjDr = prjCmd.ExecuteReader();

-----------------

the error occurs at the "dbConn.Open();" line.

I''ve got no idea why this is suddenly happening. This has been working fine,
and then has suddenly stopped. As far as I''m aware, nothing has changed on
the server.

Details...

.net 2.0
Win2k3 Server
MSDE

the Intranet is running in its own pool in IIS.

It looks like a security issue, but what?!

Any help greatly appreciated!

Cheers
Dan

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