Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Configure publishing and distribution

Author  Topic 

mko
Starting Member

2 Posts

Posted - 2003-04-02 : 17:24:09
Hi,

I am trying to configure a distributor and I want to make local server it's own distributor. After I go through the wizard, on the last step I get the following error message:
Error 18483: Could not connect to server 'xxx' because 'distributer_admin' is not defined as a remote login at the server.

Any ideas?


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-02 : 17:59:55
Take a look at sp_remoteoption stored procedure in SQL Server Books Online.

You can change the setting in Enterprise Manager. Just go to Remote servers in the Security section. Go to the properties of your server and change the options in there.

Tara
Go to Top of Page
   

- Advertisement -