asked
Linked Server setup
I am currently set up as an administrator with all of the rights available to my account. When I create a linked server I've set it up using the following settings Server Type: SQL Server For a login not defined in the list above, connections will: Be made using the login's current security context. Nothing else is changed or added. However when I go to test the connection, in my instance of SSMS on my machine, I get the error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.(Micorsoft SQL Server, Error: 18456) I dont have an account set up with that name and none of the servers I work with have that account under the Security->Logins folder. However, when I RDP into these server(s) and test the connection, it shows that the connection is successful. Is there a way to set up Linked Servers without having to RDP into to test cross server queries or sp's? I hope this question makes sense, if there is additional information that I need to provide please let me know.
It sounds like the Kerberos double-hop issue has struck for the second time this week. The problem is caused by you trying to connect from your machine to one server and then from there to another server all while just forwarding your credentials. There are a few steps needed to solve this, but fortunately I just answered this in a different question for someone else here: [
https://ask.sqlservercentral.com/questions/134643/running-query-on-server-a-need-to-get-data-from-se.html][1] Please let us know if that works for you or if you have additional questions. Good luck. [1]:
https://ask.sqlservercentral.com/questions/134643/running-query-on-server-a-need-to-get-data-from-se.html
18 People are following this question.
