December 7, 2006 at 5:59 am
Hello Everybody,
i'm having replication for database on 2 servers, the connection at the 2 sites is 512 M; download and upload is 1/4
after i did the publication and set up every thing, when the replication job start it just give "trying to connect message" then "failed to connect"
is this cause of the connection?, is there min requirements for the cnnection?
thanks
December 7, 2006 at 8:13 am
Shaimaa
I'd be surprised if it's the speed of your connection that's causing the failure. When you get the failure message, double-click on the failed agent in Enterprise Manager and you should get more details of the error.
John
December 7, 2006 at 9:32 am
You have to be carefull with sp_removedbreplication as tat remove is from the database on and does not remove the refernce to subscriptions and publications in the ditributions database. You have to remove the old reference from there which I believe I still have code for this at the house. I will send myself a note and see if I can find for you tonight but for future reference perform drop of subscription, drop of publication, and then sp_removedbreplication to clear from the database properly.
December 7, 2006 at 1:15 pm
Make sure you can linked server queries first to test the connection between the two servers before you troubleshoot your connection issue.
It could be security (login pwd) or network issue.
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply