Why Does Sp_addlinkedsrvlogin Fail Gracefully?

Running the following does not error, but it does not add the login either! When I try to add the login through EM or Studio it does not error, but when one exits the link's properties window and returns to the link's properties window the login is missing.


exec sp_addlinkedsrvlogin @rmtsrvname = 'myLink'

, @useself = 'false'

, @locallogin = 'mydomainmylogin'
, @rmtuser = 'remoteuser'

, @rmtpassword = 'remotepass'




(0 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)


It seems I can add some logins but not others. 'mydomainmylogin' is a sysadmin and is also used to start the sql server service. I can add this on most servers but not on a very few.

What gives?

Thanks,

Michael