SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Error 18483 while configuring distributor
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dontipton
Starting Member

USA
8 Posts

Posted - 09/09/2002 :  11:28:22  Show Profile  Reply with Quote
While configuring my distributor I received the following error:

Error 18483: Could not connect to server because "distributor_admin" is not defined as a remote login at the server.

Anyone have any ideas?

dtipton@state.oh.us

chadmat
The Chadinator

USA
1974 Posts

Posted - 09/09/2002 :  16:25:00  Show Profile  Visit chadmat's Homepage  Reply with Quote
Is your server registered as an IP address? If so, register it as the servername instead, then try again.

If that doesn't do it, select @@servername and make sure it matches the netbios name.

-Chad

Go to Top of Page

mko
Starting Member

2 Posts

Posted - 04/02/2003 :  17:26:18  Show Profile  Reply with Quote
I have the same problem. What do you mean that the servername should match the netbios name?

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 04/02/2003 :  18:05:44  Show Profile  Visit tkizer's Homepage  Reply with Quote
Sort of a double post:
(Edit Removed the link to post info)

This article explains NetBIOS:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnntpro00/html/NetBIOS.asp

For the most part, the NetBIOS name of the server is actually the real name of the server. Chadmat was just saying not to use the IP address as the name, but instead use the NetBIOS name.

Tara
Go to Top of Page

garyn
Starting Member

USA
5 Posts

Posted - 11/17/2011 :  18:43:16  Show Profile  Reply with Quote
I encountered this error after someone had left unfinished a failed attempt to setup ServerA as Publisher using the existing Distributor on ServerB. When I tried to run SQL2000 E/M's "Configure Publishing and Distribution" wizard on ServerA, I got this error. SSMS has separate wizards for Configuring Publishing vs Configuring Distribution, and one of those offered to drop a hidden existing (broken) Publisher partially-defined in metadata on ServerA. The wizard executed sp_dropdistributor @no_checks = 1, @ignore_distributor = 1, and the error 18483 was resolved for all client tools. I surmise a wizard had neglected in the past to create and coordinate the distributor_admin accounts & passwords between ServerA and ServerB; I never found that account on either, and it is apparently required if Publisher and Distributor are on different boxes (or instances?).
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 11/17/2011 :  21:26:52  Show Profile  Visit russell's Homepage  Reply with Quote
Thanks for dredging up an eight and a half year old post on a deprecated product.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000