Post reply

Linked server error

  • September 2, 2023 at 6:54 pm

    #4278253

    Hi,

    I created the Linked server in ServerA using the command :

    EXEC sp_addlinkedserver

    @server=N'TestLink',

    @srvproduct=N'',

    @provider=N'MSOLEDBSQL',

    @datasrc=N'ServerB;

    I am able to get the output using through linked server query - select * from TestLink.xyz.dbo.table1 in ServerA

    But when ever i am trying to query from remote server ServerC i am getting below output.

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    Please help me how to resolve the error?

     

    Thanks,

    Jo

     

  • September 3, 2023 at 7:10 pm

    #4278779

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • September 4, 2023 at 4:57 pm

    #4279303

    Hi,

    Please check below link, may help to resolve the issue.

    https://eitanblumin.com/2022/11/02/configuring-linked-server-with-delegation-step-by-step

  • September 5, 2023 at 4:36 pm

    #4279968

    That is a kerberos problem, most likely a delgation problem.

    The SQL service account both needs to be configured to enable delegation and the account using the linked server needs to be capable of using delegation. (delegation not disabled, not a member of protected user group, etc)

Viewing 4 posts - 1 through 3 (of 3 total)

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