SQL Server Linked Servers not connecting
1
vote
1
answer
2893
views
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?
Asked by MeMario
(33 rep)
Jun 8, 2020, 10:22 AM
Last activity: Dec 4, 2023, 11:03 AM
Last activity: Dec 4, 2023, 11:03 AM