Adding a linked server login

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  June 30, 2009 at 8:51 am

  #131666

  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.

  Best Regards,

  ~David

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  June 30, 2009 at 9:28 am

  #1017668

  I have solved this issue by issuing the following command:

  ALTER SERVICE MASTER KEY FORCE REGENERATE

  Best Regards,

  ~David