merge replication error

[SQLScholar]

Hey all,

I am trying to do a merge replication but i am getting this error

"The subscription to publication 'name of subscription' has expired or does not exist."

On the subscriber. I on the publisher, i have used the wizards to create the various bits and peices but the but on the publisher, the pull subcription that seems to have been added seems to be deactivated. Any ideas what i could be doing wrong.

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[SQLScholar]

Sorry i just realised how much that doesnt make sense - bad day yesterday.

created publication

1) If i try and Push to other server, says cannot connect to other server.

2) if i try and pull, it says that the publication does not exist or has expired. It does exist, i just created it - it is set not to expire.

Any help much, much, much appreciated.

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[Catadmin]

I've run into a similar problem with Transaction Rep. The servers, for some reason, don't seem able to communicate with each other. This is more a network issue than it is a SQL Server issue.

Sometimes it's caused by high network traffic accessing the publication server, and sometimes it's caused by the network connection actually going down. You have three options:

1) Wait until early in the a.m. or late at night when hardly anyone is using the network to re-initialize and run everything.

2) Kill everyone's connections except yours and re-initialize and run everything.

3) Delete the subscription on the subscriber Server, right click the publication (you may have to do this on both the sub Server and the Pub server), go to properties and the Subscriptions tab to clear the subscription from there. Then re-create the subscription (which you won't be able to do until the network connection clears).

Which ever way you choose, you still have to resolve the network connectivity issue before you can complete it and restart everything. Do a search in this group and the SQL Programming group on 'Telnet'. You'll get a list of articles to troubleshoot SQL Server connections. If you're still having trouble with the servers seeing each other, it's time to get your network guys involved.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???