定期跑步时的工作上的错误 [英] Error in job when we run on regular basis

问题描述

当我们尝试连接链接服务器以完成工作时，出现以下错误

NT AUTHORITY \ SYSTEM.用户"NT AUTHORITY \ ANONYMOUS LOGON"的登录失败. [SQLSTATE 28000](错误18456).步骤失败.

请帮助我解决问题

在此先感谢

Pratham

when we are trying to connect the link server to complete the job i am getting the below mentioned error

NT AUTHORITY\SYSTEM. Login failed for user ''NT AUTHORITY\ANONYMOUS LOGON''. [SQLSTATE 28000] (Error 18456). The step failed.

Please help me for the issue

Thanks in advance

Pratham

推荐答案

基本上，您没有定义凭据，或者目标服务器不接受凭据，因此尝试使用匿名登录.

看看这篇博客文章，它相当详尽地解释了不同的方案: http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx [

Basically you''re not defining the credentials or they are not accepted by the target server so anonymous logon is trying to be used.

Have a look at this blog post, it explains different scenarious quite thoroughly: http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx[^]

这篇关于定期跑步时的工作上的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！