Dears, kindly note I have created an external login and a remote login as following: sp_addremotelogin remoteserver,locallogin1, remotelogin1 sp_addexternallogin remoteserver,locallogin1, remotelogin1
and I log in by user locallogin1 to the localserver to the database localdb and try to create proxy table from remotedb1 on remoteserver but still get the login failed error, any body know why??
kindly note there is localuser1 aliased to locallogin1 , i.e there is no user 'locallogin1' (direct mapping) on the database localdb where I try to create proxy table, rather there is a user localuser1 is alias to locallogin1, is this related to the problem??
please advice
Dears, kindly note that the problem is solved, the case was the password, the passwords for local login and remote login are different, so I add the remote password to sp_addexternallogin as follow: exec sp_addexternlogin [remoteserver], [locallogin], [remotelogin], [remotepassword]
and every thing is well