October 29, 2019 at 1:03 pm
I am attempting to set up Replication on a new server an i am get the following error: "The Distributor system has thrown 18483 errors and failed to connect to the server because the ' distributor_admin ' does not have a remote login". Publisher and distributor are on same machine,
I have already ran the (sp_dropserver and sp_addserver 'servername', 'local') and verified that the server name matches the system name, however I am still getting this error.
Any help would be greatly welcomed.
October 29, 2019 at 3:14 pm
It sounds as if the distributor admin account has not been set up on the subscriber.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 29, 2019 at 3:21 pm
Michael L John,
I'm just trying to create the Publisher/Distributor on the first box. The error is happening when I attempt to create the Publisher/Distributor.
From my experience in the past.the subscriber part would come after Publisher/Distributor part is configured or has this changed?
Any other Ideas?
November 4, 2019 at 11:09 pm
After you do the sp_dropserver, sp_addserver, etc you need to restart the service for the change to take effect.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply