Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : Merger Replication Using SQL Express Through Https


John Luo
3/21/2006 10:43:53 AM

1. Can I initiate (create) a SQL Express merger subscription through web
Https? Is that possible? Clients are mobile users and can not connect to
the LAN to initiate the subscription. My problem is that I can't mange to
connect the publisher using websync by programming, no matter what
credentials I use.
Although I can connect remote SQL Server through the internet I cannot
create the subscription thorough wizard. The message told me that I need the
real server name (LAN server ) not alias etc.

2. Alternately I am thinking to create the subscription through snapshot? Is
this possible? If so How can I create @ SQL Express subscriber without
connect the publisher through LAN? e.g. should I just copy the all file at
snapshot directory @ publisher through FTP? How can I create this
subscription @ client using the snapshot?
John Luo
3/21/2006 8:20:26 PM
Hi, Peter,
Thank you for your response.
I just managed to create a webSyc replication @SQL Express machine. However,
to do that I have to initiate the replication manually by executing sorted
procures to create a subscriber database, a subscription @ SQL Express. I can
not use C# code to initiate the replication (Create subscriber database...).
After this the web sync works. It seems to me that I can connect the
publisher to initiate the replication by using https -basic authorization.
I do not have any problem to initiate the replication when I am in LAN
environment. After the initiation the websyc will work. I really want to
create the subscriber through the code (merge pull object) not by running
command.

I will try to delete the replication to repeat the error on a different
machine and let you know the error message.
Thanks,
petery NO[at]SPAM online.microsoft.com (
3/22/2006 3:20:54 AM
Hello John,

Based on my scope, you shall be able to create SQL Express merge
subscrption and sync with Websync

How to: Configure Web Synchronization for Merge Replication (RMO
Programming)
http://msdn2.microsoft.com/en-us/library/ms146874.aspx

Since SQL Express does not have merge agent, you may want to check SQL 2005
Sales Orders sample application under replication folder for details.

You may want to check the certificate of the IIS on the server and make
sure the certificate is bound to FQDN of IIS server. Also, client shall add
root CA certificate as trusted CA.

310178.KB.EN-US HOW TO: Install Imported Certificates on a Web Server in
Windows 2000
http://support.microsoft.com/default.aspx?scid=KB;EN-US;310178

299875.KB.EN-US HOW TO: Implement SSL on a Windows 2000 IIS 5.0 Computer
http://support.microsoft.com/default.aspx?scid=KB;EN-US;299875

What is the exact error message you encounter when using RMO to sync? Does
it work if you run the applicaiton inside LAN?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
[quoted text, click to view]
AddThis Social Bookmark Button