SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2005 merge replication across non trusted servers


SQL 2005 merge replication across non trusted servers

Author
Message
vainfreeman
vainfreeman
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 14
Is it possible to set up merge replication between two servers that are not on the same network. We are looking to replicate from one of our client machines to our server. I have set up merge replication with a push subscription. I don't fully understand the account requirements for the reciever (subscriber) to participate with the client server. The merge agent is failing when i attempt to subscribe across machines but works fine on the same box.
Michael Earl-395764
Michael Earl-395764
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13329 Visits: 23078
Yes, in fact you can configure merge replication over http or https with both named and anonymous subscriptions.
The books online instructions are not bad.
vainfreeman
vainfreeman
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 14
Thanks for your response. I have looked at the books online documentation and it does cover this issue but it is not clear how the replication merge agent account is setup for authentication on the subscriber for a non domain machine. Also since I am performing a push subscription does the subscriber need access to the snapshot folder?
Michael Earl-395764
Michael Earl-395764
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13329 Visits: 23078
The subscriber either needs to be able to use an NT login that is valid in the publishing database, or you will need to use SQL authentication. Using SQL authentication will make this far easier for you to set up.
As far as the snapshot folder, if you manually set up the initial database, you technically never need access to the snapshot folders from the subscriber. You can set up and run merge replication without using the snapshot agent at all. In practice, this is typically not the way to go. You will usually want to be able to have the snapshot agent reinitialize your database as necessary or send schema changes to your subscribers. Luckily, you have the option during the wizard to use an ftp folder for the snapshot folder. You configure the publishing database to use a local folder on it's network and then publish this folder via ftp to make it available to the subscribers.

Securing this can be a bit of a trick as ftp is not very secure, but if you have someone around that knows a bit about web security, authentication can be handled through certificates.
vainfreeman
vainfreeman
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 14
Thanks. I have configured a push replication with all agents running on the publisher, will the subscriber need access to the snapshot folder in this case? I would like to be able to replicate schema changes as well as replicate data from the subscriber to the publisher. If i understand the security requirements correctly i can use a valid Windows Account setup for replication for the merge agent to run on the publisher and a SQL login for the subscriber database.

Again thanks for your assistence.
LemonLuv
LemonLuv
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 26
Hello I am Having the same problem. Could anyone help me?

Here is the scenario.
1. I have 2 MS SQL Server 2005 each residing in different computers.

server1> area1\sqlExpress
server2> area2\sqlExpress

2. I have already configured the Distributor to have the snapshot saved in the accesible drive (external hard disk, accessible to all)

snapshot folder> \\extdrive\sqlsnapshot

3. I have also used SQL Server Agent Authentication

4. I have tried performing Merge Replciation and during first run,

1. the process was performed and the database is copied to server2

5. But when i try running the process again so that the changes in my subscriber will be copied to the publisher, (means no reinitialization in the subscriber), the SQL Server gives this message:

The Server server2\SQLExpress is not a Subscriber. (.Net SQLClient DataProvider)

I hope somebody could help me. Thank you.

(Btw, I am new in replication)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search