SQL Server凭据映射到网络服务帐户的问题(Issue with SQL Server Credential mapped to Network Service account)

SQL Server凭据映射到网络服务帐户的问题(Issue with SQL Server Credential mapped to Network Service account)

在SQL Server 2008 R2标准版上，我创建了一个credential TestCredential，其identity为NT AUTHORITY\NETWORK SERVICE ，如此处所述 。 然后，我按照本文使用该代理帐户创建proxy account和SQL服务器作业。 但是当我运行这个工作时，我收到以下错误：

Unable to start execution of step 1 (reason: Error authenticating proxy NT AUTHORITY\NETWORK SERVICE, system error: Logon failure: unknown user name or bad password.). The step failed.

On SQL Server 2008 R2 Standard Edition, I created a credential TestCredential with identity as NT AUTHORITY\NETWORK SERVICE as explained here. Then I followed this article to create a proxy account and a SQL server job using that proxy account. But when I run the job, I get the following error:

Unable to start execution of step 1 (reason: Error authenticating proxy NT AUTHORITY\NETWORK SERVICE, system error: Logon failure: unknown user name or bad password.). The step failed.

最满意答案

错误的内容告诉你一切。 您可以为没有密码的服务帐户创建凭据，这是执行此操作所必需的。 如果您转到“Credentianals”部分，您会发现此凭据的密码对于此帐户是错误的。 总之，您不能将服务帐户用作凭证。 他们的角色是服务“处理”。

Error's content tells you everything. You create credential for service account without password which is required to do this. If you go to the "Credentianals" section you will find this credential with password which is wrong for this account. In conclusion you can not use service accounts as a credential. Their role is to service "handling".