question

Robp avatar image
Robp 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.
linked serverkerberos
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tom Staab avatar image
Tom Staab answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.