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] >Thread-Topic: Merger Replication Using SQL Express Through Https
>thread-index: AcZNF2bh6w9nnrziSTimtbt+lB313g==
>X-WBNR-Posting-Host: 24.98.120.243
>From: =?Utf-8?B?Sm9obiBMdW8=?= <luoo@nospam.nospam>
>Subject: Merger Replication Using SQL Express Through Https
>Date: Tue, 21 Mar 2006 10:43:53 -0800
>Lines: 16
>Message-ID: <4DF4197C-C211-4C5F-A3FA-03AAB762F9C7@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.replication
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.replication:70113
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>
>
>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
>