Post reply

Login Failed for user 'NT Authority\ANONYMOUS LOGON'

  • September 17, 2009 at 1:12 pm

    #385388

    We added a new SQL server.

    When I run a proc from the old server, that references the new server - I get the Login Failed for user 'NT Authority\ANONYMOUS LOGON' error.

    Ive read many things online, and added a linked server (both servers).

    I checked my sql agent accounts and they both use the exact same account.

    I'm stuck....any ideas?

  • September 17, 2009 at 1:30 pm

    #1055242

    Check the Local Security Policy for this ID

  • September 17, 2009 at 1:59 pm

    #1055255

    Can you elaborate?

    I looked for my user and didn't see him?

  • September 17, 2009 at 2:21 pm

    #1055264

    add the account to local security policy.

  • September 18, 2009 at 6:56 am

    #1055558

    what setting in local setting in local security policy?

  • September 22, 2009 at 1:36 am

    #1056591

    Hi krypto69,

    What Security mode your linked server is using?

    Basically, seems like your linked server user account is failed to handshake with the partner server and that's why SQL Server raised this error message to you.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply