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.
| Author |
Topic |
|
ryan.gillies
Starting Member
27 Posts |
 Posted - 2012-07-30 : 07:35:53
|
Hi allI'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 1Login 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. |
 |
|
|
|
|
|
Cannot connect to Linked Server