Post reply

Linked server

  • February 25, 2020 at 11:00 pm

    #3728758

    I have created linked server from instance A to instance B. when i do a test connection it is successful but when i try to do a test connection from outside the server it shows login failed for user NT authority\anonymous logon. Any inputs?

     

    i registered SPN for services in both instance A and instance B.

  • February 26, 2020 at 8:36 am

    #3728819

    Are the services running as service accounts?  Have you granted trusted for delegation to the accounts in AD?

  • February 26, 2020 at 4:54 pm

    #3728982

    Yes i did and one more thing do i need to restart SQL server post SPN registration.

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

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