Hello, I have created a new linked server and that was successful. When I attempt to add a new linked server login it fails with the following error message:
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 'sa' mapped to local user '(null)' from the remote server 'EMERSONS'.
Here is the code I used to create the linked server and linked server login:
EXEC master.dbo.sp_addlinkedserver @server = N'EMERSONS', @srvproduct=N'SQL Server'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'EMERSONS',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='sysadmin'
Any ideas on how I can get past this. Your help is greatly appreciated.