December 3, 2013 at 12:46 pm
I have a linked server set up that works with my credentials, and it works with a low level SQL account that is the same name and password on both servers.... I'll call that sql account "Basic_Login"
But what I would like to do is have an application that connects to server A (source) using "AppLogin" copy records via linked server from ServerA to Server B. "AppLogin" exists on both servers, but has different passwords. (If I set the passwords the same it works)
So, I thought I could configure the Linked Server to use the permissions of "Basic_Login", and allow "AppLogin" to make use of it. I have tried various settings within the linked server but always get an error when running the code: "Login failed for user AppLogin."
or get an error trying to configure the Linked Server
[font="Courier New"]There is no remote user 'AppLogin' mapped to local user '(null)' from the remote
server "LinkedServer".[/font]
December 3, 2013 at 11:44 pm
try this
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname = N'<REMOTE_SERVER>',
@locallogin = N'AppLogin',
@useself = N'False',
@rmtuser = N'Basic_Login',
@rmtpassword = N'<Basic_Login_Password>'
December 4, 2013 at 8:22 am
I think I tried the GUI version of that already. When I try now I get the error
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'AppLogin' mapped to local user 'AppLogin' from the remote server 'LinkedServer'.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply