Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Configuring Replication Expand / Collapse
Posted Tuesday, December 18, 2007 2:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 20, 2016 2:19 AM
Points: 225, Visits: 479

I want to configure transactional replication between two servers with sql server 2005, I want to know whether both the servers and the third server on which I've created the network share folder to save the snapshots should be in same domain or not. In this case all three servers are stand alone servers, they doesn't belong to any domain. Is it possible to configure replication in this case and if yes then can you plz tell me the steps involved?

Post #434169
Posted Tuesday, December 18, 2007 5:25 AM


Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
For security and sanity, I would put them all on the same domain. However, this is not absolutely necessary.

SQL Replication will work using SQL Authentication. You can configure your transactional replication using SQL Logins and it should work fine. Since you are using a shared snapshot folder, you will probably have to configure folder access allowing permissions to "Everyone" (hence your security problem).
Post #434212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse