SQL 2000 18483 Error

Last Post 12 Nov 2007 06:28 AM by PaulMcKibben. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
07 Nov 2007 10:29 AM
I get the error 18483 "Could not connect to server X becuase 'distributor_admin' is not defined as a remote login at the server.

I had the server registered as X previously and had issues when executing a pull subscription from a new SQL 2000 server. I then deleted the registration and registered the server as its IP and recieved the same message when configuring a publication. I then deleted the registration and registered the server as its full DNS name and recieved the same message when configuring a publication.

I have the same sql login on both servers as a systems adminstrator.

Any assistance would be greatly appreciated.
PaulMcKibben
New Member
New Member

--
12 Nov 2007 06:28 AM
I did run the 'select @@servername' statement as you suggested. The names matched. These server are in two separate workgroups.

You are not authorized to post a reply.

Acceptable Use Policy