Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configuring Replication Expand / Collapse
Author
Message
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: Friday, June 13, 2014 4:15 AM
Points: 225, Visits: 464
Hello,

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?

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, 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