Configuring Replication

  • 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

  • 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).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply