March 17, 2015 at 2:02 pm
I created a linked server (on SQL 2005) with security mode "be made using login's current security context" to a SQL 2012 instance on another server. We're using Windows authentication. When I use the link from the server it is created on it works fine. But when I try to use it from my pc it works sometimes but then other times I get error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. In the linked server Server Options section I set RPC and RPC Out to TRUE. I realize that this is a double-hop and I may have to set some Windows delegation, but why does this link work sometimes? It seems like if I go on the server where the link is and open and close it, then it will work for a while from my pc. But after a while the login fail error comes back. Does anyone know why this is and what I can do to fix it? What Windows settings do I have to change?
Thanks very much for any ideas.
March 17, 2015 at 3:48 pm
Denise McMillan (3/17/2015)
I created a linked server (on SQL 2005) with security mode "be made using login's current security context" to a SQL 2012 instance on another server. We're using Windows authentication. When I use the link from the server it is created on it works fine. But when I try to use it from my pc it works sometimes but then other times I get error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. In the linked server Server Options section I set RPC and RPC Out to TRUE. I realize that this is a double-hop and I may have to set some Windows delegation, but why does this link work sometimes? It seems like if I go on the server where the link is and open and close it, then it will work for a while from my pc. But after a while the login fail error comes back. Does anyone know why this is and what I can do to fix it? What Windows settings do I have to change?Thanks very much for any ideas.
Quick questions, can you describe the infrastructure in a slightly more details? My thought is that's what you perceive as double hops are in fact single hops.
😎
March 19, 2015 at 9:30 am
On SQL Server 2005, sp3, standard ed, 32bit instance I created the linked server to a SQL Server 2012, sp1, standard ed, 64bit instance. The link is SQL Server type, Provider is Microsoft OLE DB Provider for SQL Server, Security is to be made using the login's current security context, and options RPC and RPC Out are set True. When I'm on the server where the link is I can use it, works fine. But from my pc it only works sometimes. Like after I open the link properties on the server and just OK out of it. Then it works from my pc for a while, but eventually goes back to Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
What else can I tell you to help solve this mystery?
And thanks so much for helping me with it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply