1

I have configured linked servers with "connections will be made using the login's current security context", but can only make use of them when logged on to the server, not from another machine...

Works fine:

SSMS --> SQL_SERVER_A --linked server--> SQL_SERVER_B
The test connection to the linked server succeeded

Does not work:

SSMS --> ADMIN_PC --> SQL_SERVER_A ---linked server--> SQL_SERVER_B
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)

I've ran the 'Kerberos Configuration Manager for SQL Server' and everything checks OK and user I'm using is the same.

Does someone have an idea what could be the problem?

4
  • it related to delegation problem please look at this sql-server-returns-error-login-failed-for-user-nt-authority-anonymous-logon
    – Sayadian
    Jun 9, 2020 at 13:05
  • From the AdminPC is the user logging into SSMS as an admin - for example, right click>run as admin when SSMS is launched?
    – rvsc48
    Jun 9, 2020 at 14:26
  • Despite what the Kerberos Config Manager says, Kerberos is most likely broken on your company's network and you're facing the 'double hop' issue. It's a very common problem. Speak to your AD administrator, if he cant fix it there is the delegation work around.
    – Jhunter1
    Jun 10, 2020 at 13:58
  • @rvsc48 The result is the same
    – MeMario
    Jun 10, 2020 at 14:19

1 Answer 1

0

This is a common error in delegation permission for the linked server connection however you can fix it checking the Kerberos Connectivity or adding but none recommendable SQL Login ID in your Linked Server Connection.

You can find more details on how to use the Kerberos Connection Manager and add the delegation permissions on your AD based on this article. https://www.sqlshack.com/how-to-link-two-sql-server-instances-with-kerberos/

enter image description here!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.