Monday, March 26, 2012

Error when running Agent in Merge Replication!

Hi All:
I am trying to setup a Merge Replication over Internet. Snapshot runs
successfully, but when it tries to run sycronize the data for ther first
time, it gives the following error in the end:
The Subscription to Publication 'xxxx' is invalid
'xxxx' is the Database Name
The connectivity to the remote DB is working.
One of the reasons for this swich I found was the the remote server's name
was changed after SQL server was installed. Therefore the old name was
dropeed b y using these:
sp_dropserver <server name>
go
sp_addserver <new server name> , LOCAL
go
After doing this, we still get the same message "The Subscription to
Publication 'xxxx' is invalid"
Please suggest the remedy for this.
Thanks,
Anukul
anukul,
Just for grins, check that the publisher is aware of the new server name. If not you can either drop the subscription in both places and re-create or alter the subscription in both places to utilize the new machine name.
Give it a shot. Worst case it doesn't work...|||If you changed the server name after configuring the Subscriber, the
Publisher doesn't know about the new server name. You need to drop and
recreate the subscription at the Subscriber and re-register the Subscriber
with the Publisher, using the following stored procedures:
? sp_dropmergepullsubscription at the Subscriber (only if the Merge Agent
runs at the Subscriber, a pull subscription).
? sp_dropmergesubscription at the Publisher.
? sp_dropsubscriber at the Publisher.
You should also be able to do this from Enterprise Manager.
Then you must re-register the Subscriber using sp_addsubscriber or (from
Enterprise Manager) and recreate the subscription using either Enterprise
Manager or executing sp_addmergesubscription at the Publisher and
sp_addmergepullsubscription (only if the Merge Agent runs at the Subscriber,
a pull subscription).
Best wishes,
Glenn Gailey
SQL Server User Education
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anukul" wrote:

> Hi All:
> I am trying to setup a Merge Replication over Internet. Snapshot runs
> successfully, but when it tries to run sycronize the data for ther first
> time, it gives the following error in the end:
> The Subscription to Publication 'xxxx' is invalid
> 'xxxx' is the Database Name
> The connectivity to the remote DB is working.
> One of the reasons for this swich I found was the the remote server's name
> was changed after SQL server was installed. Therefore the old name was
> dropeed b y using these:
> sp_dropserver <server name>
> go
> sp_addserver <new server name> , LOCAL
> go
> After doing this, we still get the same message "The Subscription to
> Publication 'xxxx' is invalid"
> Please suggest the remedy for this.
> Thanks,
> Anukul
>
>

No comments:

Post a Comment