Re: sync over the Internet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Can you connect to your publisher from home? If not you I believe you will
have to connect via code. Feel free to contact me offline for more info.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"carol" <carol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2EFC02D1-75A8-463B-BAB7-6C9417BF2164@xxxxxxxxxxxxxxxx
Hi,

I am sorry being a pain. I have tried the method you said, but that only
works fine on the company LAN. My question is if I try to creat a
subsription
from my home PC, how do I connect to Publisher?

I've read some articels about configuring remote connection, but that's
only
apply to Express and Develop edition. My server is using Standard edition,
do
I still need to configure it?

Massive thanks.............

"Hilary Cotter" wrote:

First off have them connect to the web server using https and
install/accept
the certificate. Ensure that they use an url which reflects the url in
the
certificate, ie https://www.Mydomain.com or https://websync.hostname

Then have them connect to
https://www.mydomain.com/myReplicationVirtualDirectory/replisapi.dll?diag
and ensure that everything is successful.

Once this is done they are ready to set up their subscription. In SSMS,
connect with your express subscriber, expand the replication folder,
right
click on local subscriptions and select new subscriptions, click next,
select your publisher
Have them also connect to the Publisher, expand the database, select the
publication and click next, select pull subscriptions (run each agent at
its
subscriber), keep on clicking until you get to the web synchronization
dialog, check the use web synchronization check box. Enter the name of
your
web server and the virtual directory make sure the server name matches
what
it looks like in the certificatie. If you are using basic authentication
enter the account and password, otherwise use the windows synchronization
account.Complete the rest of the dialog accepting defaults.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"carol" <carol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD883D98-F8CC-4C3D-A6D0-2185A5207B86@xxxxxxxxxxxxxxxx
Thanks for your reply. I do wanna sync over HTTPS and in fact i have
had
SSL
certificate and IIS configured. now as some subscribers are not on
company
network, how do they create subscription from their SQL Server
Management
Studio?

"Hilary Cotter" wrote:

If you don't want to synchronize over https where your merge
subscribers
will connect to a web server and download the snapshot from there, it
is
recommended that they pull their initial snapshot via a ftp server.

Check out this article for more info.

http://www.dbazine.com/sql/sql-articles/cotter4

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business
intelligence.

This posting is my own and doesn't necessarily represent
RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"carol" <carol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:648518F6-4DB9-4274-B998-FD9E9FF15A93@xxxxxxxxxxxxxxxx
Hi,

i have created a merge publication on the server (SQL 2k5 Standard).
serveral subscribers (SQL 2k5 Express) sync over the Internet. As
they
don't
have fixed IP address, so that i have enabled the anonymous
subscription
at
the publisher. What else do i need to do to make it work? Is there
any
documentations provide step-by-step instruction? Do I have to have a
FTP
server?

Thanks








.

Relevant Pages

  • Re: Load Balanced Web Synchronization Against a Republisher Topology &
    ... Looking for a SQL Server replication book? ... We use RMO to setup the pull subscription on the client ... properties necessary to use Web Synchronization. ... Name of the Publisher for PublisherName. ...
    (microsoft.public.sqlserver.replication)
  • Future Maintenance of SQL 2005 Merge Replication
    ... I have remote offices that are entering data into their local database, ... server, and then possibly download any changes made on my web server. ... Then I'll send them instructions on how to start a subscription. ... restored (on either the subscription side or publisher side) that as long as ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem in pulling subscription
    ... Best Regards ... Looking for a SQL Server replication book? ... When I Pull Subscription from other location it fails, ...
    (microsoft.public.sqlserver.replication)
  • Re: Subscription from Mobile to Desktop database problem
    ... The only thing I can think of is that your server ... Configure Publishing or Configure Distribution on ... a publisher and/or distributor. ... > Server when I attempt to create the subscription on the Mobile DB. ...
    (microsoft.public.sqlserver.ce)
  • attaching subscription database woes
    ... My plan is to ship copies of a subscription ... the new subscription database. ... move the copy to target server. ... on the publisher - drill down to the publisher list, ...
    (microsoft.public.sqlserver.replication)