Error 21776: PUBLISHER_NAME not found in DistributionPublishers collection

While trying to set up remote distribution on server PUBLISHER_NAME, I
get the above error when trying to specify the remote distributor.
(Error 21776: PUBLISHER_NAME not found in DistributionPublishers
collection on DISTRIBUTOR_NAME)
However, I have set up distribution on DISTRIBUTOR_NAME, and in the
Publishers tab of that window, I have checked the entry for
PUBLISHER_NAME. The alias for that server matches exactly the
PUBLISHER_NAME.
Do I need to restart the SQL Server for this entry to be acknowledged?
Is there some other step of configuration I am missing? Why doesn't the
PUBLISHER_NAME see that it's name is indeed on the authorized publisher
list for DISTRIBUTOR_NAME?
Thanks in advance for any help,
Jason
Its hard to say. Can you connect with your distributor and issue the
following commands for me. Post the results back here.
On your distributor
sp_helpdistpublisher 'RemotePublisherName'
On your remote publisher issue the following
sp_helpdistpublisher 'RemotePublisherName'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<iaesun@.yahoo.com> wrote in message
news:1112369037.970196.9940@.l41g2000cwc.googlegrou ps.com...
> While trying to set up remote distribution on server PUBLISHER_NAME, I
> get the above error when trying to specify the remote distributor.
> (Error 21776: PUBLISHER_NAME not found in DistributionPublishers
> collection on DISTRIBUTOR_NAME)
> However, I have set up distribution on DISTRIBUTOR_NAME, and in the
> Publishers tab of that window, I have checked the entry for
> PUBLISHER_NAME. The alias for that server matches exactly the
> PUBLISHER_NAME.
> Do I need to restart the SQL Server for this entry to be acknowledged?
> Is there some other step of configuration I am missing? Why doesn't the
> PUBLISHER_NAME see that it's name is indeed on the authorized publisher
> list for DISTRIBUTOR_NAME?
> Thanks in advance for any help,
> Jason
>
|||i'm very sorry for taking so long to get back to you. i was told to
stop setting up publishing and be a developer for a couple of weeks.
but that's over now, so i am back to this task.
firstly, thank you very much for your help, here are the results you
requested to see:
sp_helpdistpublisher 'RemotePublisherName' run on the distributor
reported:
"The remote server does not exist or has not been designated as a valid
publisher."
sp_helpdistpublisher 'RemoteDistributorName' run on the publisher
reported:
'RemoteDistributorName' is not configured as a Distributor.
however i have verified that on RemoteDistributorName that
RemotePublisherName is listed in the Publishers tab of the "Publisher
and Distrubutor Properties" window, and it is checked as a valid
publisher.
jason