NT AUTHORITY \ ANONYMOUS LOGON --- SQL服务器 [英] NT AUTHORITY\ANONYMOUS LOGON --- SQL server

问题描述

我有计算机A这是运行Win2K3和MS SQL服务器。并且

计算机B正在运行我创建的服务。如果我在计算机B上更改

服务作为用户运行我的程序能够将b $ b连接到计算机A上的SQL服务器。正确。但是，如果我将服务设置在

计算机B上。作为一个本地系统运行然后我得到一个错误连接到计算机A上的

SQL ---NT AUTHORITY'ANANMOUS LOGON。我明白为什么我有b $ b有错误但更喜欢将服务设置为本地系统

而不是在用户帐户下运行它。

所以问题是如何重新配置​​SqlConnection连接

字符串，这样用户不是匿名的，或者告诉SQL服务器它没关系

这台计算机要登录。我不想让匿名登录到我的SQL

服务器，但是我对使用SQL用户名并不感到高兴

密码。


提前致谢，

John

I have "Computer A" which is running Win2K3 and MS SQL server. And
"Computer B" which is running a service that I have created. If I change
the service on "Computer B" to run as a user my program is able to connect
to the SQL server on "Computer A" correctly. But if I set the service on
"Computer B" to run as a local system then I get an error connecting to the
SQL on "Computer A" --- "NT AUTHORITY\ANONYMOUS LOGON". I understand why I
have the error but would prefer to keep the service set to local system
rather then running it under a user account.

So the question is how to either reconfigure the SqlConnection connection
string so the user is not anonymous or to tell the SQL server it''s ok for
this computer to log in. I don''t want to allow anonymous log in to my SQL
server obivously but I am not really happy about using the SQL user name and
password either.

Thanks in advance,
John

推荐答案

那么，它被称为本地的原因服务是因为它被设计为在计算机内使用，而不是通过网络使用。


有一个名为NT AUTHORITY的特殊帐户网络服务"

允许您远程连接。配置服务时，您可以将
指定为您的用户帐户（无需密码）。这导致Windows

将机器域凭据发送到sqlserver，因此SqlServer

会看到类似mydomain \ ComputerB

Well, the reason it is called "local" service is because it is designed to
be used within the computer, not across a network.

There is a special account called "NT AUTHORITY\NetworkService" which will
allow you to connect remotely. When configuring the service, you can
specify this as your user account (no password needed). This causes Windows
to send the machines domain credentials to sqlserver, therefore SqlServer
would see something like "mydomain\ComputerB

" （美元符号很重要）。

只需将此帐户添加到SqlServer，您就可以连接。

" John J. Hughes II" < [e-mail]>在消息中写道

news：es ************** @ TK2MSFTNGP14.phx.gbl ...

" (dollar sign is important).
Just add this account to SqlServer and you should be able to connect.
"John J. Hughes II" <[e-mail]> wrote in message
news:es**************@TK2MSFTNGP14.phx.gbl...

我有电脑 A"这是运行Win2K3和MS SQL服务器。并且
计算机B正在运行我创建的服务。如果我在计算机B上更改了服务。作为用户运行我的程序能够连接到计算机A上的SQL服务器。正确。但是，如果我在计算机B上设置服务。作为本地系统运行然后我得到一个错误连接到
SQL onComputer A ---NT AUTHORITY'ANANMOUS LOGON。我理解为什么
我有错误，但更愿意将服务设置保留到本地系统
而不是在用户帐户下运行。

所以问题是如何重新配置SqlConnection连接
字符串，以便用户不是匿名的，或者告诉SQL服务器，这台计算机可以登录。我不想让匿名登录到我的SQL
服务器显而易见，但我对使用SQL用户名
和密码感到高兴。

提前致谢，
John

I have "Computer A" which is running Win2K3 and MS SQL server. And
"Computer B" which is running a service that I have created. If I change
the service on "Computer B" to run as a user my program is able to connect
to the SQL server on "Computer A" correctly. But if I set the service on
"Computer B" to run as a local system then I get an error connecting to the SQL on "Computer A" --- "NT AUTHORITY\ANONYMOUS LOGON". I understand why I have the error but would prefer to keep the service set to local system
rather then running it under a user account.

So the question is how to either reconfigure the SqlConnection connection
string so the user is not anonymous or to tell the SQL server it''s ok for
this computer to log in. I don''t want to allow anonymous log in to my SQL
server obivously but I am not really happy about using the SQL user name and password either.

Thanks in advance,
John

" Peter Rilling" < PE *** @ nospam.rilling.net>在留言中写道

新闻：eQ *************** @ TK2MSFTNGP15.phx.gbl ...

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:eQ***************@TK2MSFTNGP15.phx.gbl...

好吧，原因它被称为本地服务是因为它被设计为在计算机内使用，而不是通过网络使用。

有一个名为NT AUTHORITY \NetworkService的特殊帐户。这将允许您远程连接。配置服务时，您可以将其指定为您的用户帐户（无需密码）。这导致Windows
将机器域凭据发送到sqlserver，因此SqlServer会看到类似mydomain\ComputerB

Well, the reason it is called "local" service is because it is designed to
be used within the computer, not across a network.

There is a special account called "NT AUTHORITY\NetworkService" which will
allow you to connect remotely. When configuring the service, you can
specify this as your user account (no password needed). This causes
Windows
to send the machines domain credentials to sqlserver, therefore SqlServer
would see something like "mydomain\ComputerB

这篇关于NT AUTHORITY \ ANONYMOUS LOGON --- SQL服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！