Windows authentication login issue
-
I have a new 2005 setup (server1) running on Windows 2003 and using Windows only authentication. I have defined a new AD group for the authorised users of server1. From time to time there will be a need to run a query against another server (server2) which has mixed mode security, but I do not want the users to be able to access server2 directly themselves.
In an attempt to achieve this, I have created a linked server to server2 from server1 and have specified that the connection 'Be made using this security context', giving it the name and password of a new user that was created specially for this purpose. I have defined this user as a Windows login on server 2 and given it the appropriate rights.
Unfortunately, every time I try to run a query via the linked server connection I am getting:
OLE DB provider "SQLNCLI" for linked server "server1" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18456, Level 14, State 1, Line 0
Login failed for user 'testuser'.
This problem is driving me mad! I assume it's got something to do with the login being declared as a windows login on server2 but I don't really want to use SQL Server logins as I'm trying to get away from that. Could someone PLEASE tell me if what I am trying to achieve is possible or even preferable - is there a better way to achieve this? Thank you, thank you, thank you!!!
-
Debbie, did Eswin's links help you?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply