I am getting error message: A security error occurred Server, Publisher, Distributer same comp. Win 2003, IIS 6, SQL 2005 Standard. Dont have static IP yet, using no-ip service. Tried security certificate using selfSSL, got error, tried thwart trial certificate valid for 20 days, still gives warning...

Hi, I recommend to refer this article and then go further setting up replication over VPN http://support.microsoft.com/kb/321822

This support/kb link worked for me, can you please recheck!!

Hello there, I'm searching for the best solution to scale out transactional replication with hundreds of publications, and that's the situation: we use transactional replication (push, no update) with almost 100 articles (tables and sp) on sql2k5. We've the online database, that expose a...

Hi, in addition to what Satya has suggested plz refer http://msdn2.microsoft.com/en-us/library/ms151319.aspx , I have recently worked on this requirement using dedicated VPN connection