Friday, February 24, 2012

could not connect to server because distributor_admin is not defin

The Distributor is not available
Error 18483 coult not connect to server "VNSV20009' because
'distributor_admin' is not defined as a remote login at the server.
Here is the scenario. We have 1 SQL server that replicates to another local
reporting server, and a server on the internet. They were all working fine
before today , but now i get this error. I think it started happening when
our developer tried adding the report server as a linked server instead of a
remote server... anyone have any ideas on this one?
Thanks,
Justin
I think the developer probably dropped the remote server and then readded
it.
Your best bet is to dropped the linked server and then reenable your
subscriber. You do this through the EM menu options Tools - Replication -
Configure Publishers, Subscribers, and Distributor and then go the the
Subscribers tab and check the check box to the left of your subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Justin" <Justin@.discussions.microsoft.com> wrote in message
news:EC2EFC26-F356-4138-9BA5-08BFC6F54E28@.microsoft.com...
> The Distributor is not available
> Error 18483 coult not connect to server "VNSV20009' because
> 'distributor_admin' is not defined as a remote login at the server.
> Here is the scenario. We have 1 SQL server that replicates to another
local
> reporting server, and a server on the internet. They were all working fine
> before today , but now i get this error. I think it started happening when
> our developer tried adding the report server as a linked server instead of
a
> remote server... anyone have any ideas on this one?
> Thanks,
> Justin

No comments:

Post a Comment