Remote server and login

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello sir,

Now i can install a replication:(( I want to install a replication with option 'Remote -Use Existing Remote Distribution Server' in the server anc20 and the server remote is anc60; but i receive this message(in the server anc20): ->Unable to connect to site 'anc60' because 'sa' is not defined as a remote login at the site. I execute this commande at the site: ->sp_addremotelogin anc60,sa,sa i receive this message: ->Error 15068: There is already a remote user named 'sa' for remote server 'anc60'.

Advice me please...

-- Anonymous, October 05, 1999

Answers

Tezniti,

In Microsoft SQL Enterprise Manager, select your calling server. Open Server/Remote Servers... Make sure your remote server is configured as remote with the RPC option and the sa login mapped to the sa login.

Then repeat the same setup in the opposite direction - select your remote server and make sure your calling server is configured as remote with the RPC option and the sa login mapped to the sa login.

Hope this helps,

Eric

-- Anonymous, October 05, 1999


Moderation questions? read the FAQ