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...

when I did this I have faced a problem in connecting subscriber and the issue is distributer was not able to identify and resolve subscriber by its actual physical netbios name i.e. subscriber1, where as it can able to find and ping it with fully qualified dns name i.e. subscriber1.somedomain.local....

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!!

Hi, This will be helpful to you http://msdn2.microsoft.com/en-us/library/ms151319.aspx & http://support.microsoft.com/kb/321822

BUENOS DIAS, TENGO UN PROBLEMA. TENGO UN SERVIDOR WIN 2003 EE, Y Microsoft SQL Server 2005 - Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) , TENGO 11 EQUIPOS WINXP SP2 Y TENGO EL SIGUIENTE MENSAJE: No pudo aplicarse en el destino el cambio de la fila con el sobrenombre de artículo 52765001...

Yes, if you are looking to setup replication on physically dispersed network over internet above link will help you, apart from this http://support.microsoft.com/kb/321822 article will be useful to you

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