Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Cannot connect to Linked Server

Author  Topic 

ryan.gillies
Starting Member

27 Posts

Posted - 2012-07-30 : 07:35:53
Hi all

I've set up a linked server on SQL Server Express 2008, but I'm having trouble accessing it. All server's in question use Windows Authentication, and in this instance, it is the same windows user in each instance.

As far as I can tell I have correctly set up the security features of the linked server to use the 'Be made using the login's current security context' option.

If I sit on the server machine and run any queries that reference the linked server, the results come back fine. If I connect to my SQL Server using the same windows ID from another workstation and run the query I get the following error:

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I assume something is going wrong when I remotely connect to the server, but I can't quite figure out what.

Can anyone help?

ryan.gillies
Starting Member

27 Posts

Posted - 2012-07-30 : 08:06:29
Just to follow up on my last post, I now realise its a "double hopping" issue (http://support.microsoft.com/kb/238477) that I'm currently facing.

Unfortunately the solution described in the knowledge base can't be implemented in this instance, as I have no control over user authentication on the linked server.
Go to Top of Page
   

- Advertisement -