how do I configure user access for merge synchronisation?

Question

I Have a Replicable database which I (as the creator) can access Ok

I want to allow other users on the VPN to synchronise with this using SMO, I have a working application and the database is set up for remote connections and mixed mode authentication.

Do I set the new users up on the database using their normal windows passwords if so what objects, roles should I give them or anything else to provide the most painless and secure access

Thank you

---

jnc

Answer 1

Yes you can synchronize over VPN, but not sure how you do this via SMO.  Did you mean RMO?  Here's info on publishg data over the internet using VPN.  http://msdn.microsoft.com/en-us/library/ms152569.aspx

As far as security, you can read more about the replication security mode here: http://msdn.microsoft.com/en-us/library/ms151187.aspx.

Answer 2

Thanks

I do have a working model I connect OK to my client and the syncro is fine my problem is configuring SQL server to allow users other than myself access

---

jnc

Answer 3

If they use windows accounts they should be in the publc role in the publisher publication database, and in the pal.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 4

Thank you (once more)

---

jnc