SQL SERVER 2005 - Problem  with sp_addlinkedsrvlogin

GuyHochman
GuyHochman used Ask the Experts™
on
Hi
When I am executing

USE [master]
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'REAL_DB_SQL', @locallogin = NULL , @useself = N'False', @rmtuser = N'RealCas_RND_remote_server', @rmtpassword = N'RealCas_RND_remote_server'

I get this 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 'RealCas_RND_remote_server' mapped to local user '(null)' from the remote server 'REAL_DB_SQL'.


1. RealCas_RND_remote_server  login exisnt on the destanation server and the password is correct
2 both instances services (source and destenation)  started with DOMAIN\sqlservice user that is administrator on the machin
3. both instances (source and destenation) are on the same machin


Thanks in advence
Guy H

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
don't use this parameter: @locallogin = NULL
this is the default, and your trying to use user name "NULL", which isn't the same thing!

Author

Commented:
I execute
USE [master]
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'REAL_DB_SQL',  @useself = N'False', @rmtuser = N'RealCas_RND_remote_server', @rmtpassword = N'RealCas_RND_remote_server'
GO
and got the same 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 'RealCas_RND_remote_server' mapped to local user '(null)' from the remote server 'REAL_DB_SQL'.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial