Active Directory setup and SQL Server replication

  • Thread starter Thread starter TiaatrV
  • Start date Start date
T

TiaatrV

Thanks in advance for any help you guys can provide...

This is the setup I have:
a) SQL Server 2000 Standard running on Windows 2000 Server at multiple co-lo
sites
b) No VPN between the sites

I would like to be able to do replication between the sites so if a value is
changed at any site it is replicated to all of the others (that's not the issue
being addressed here, just background info).

What do I need to setup in terms of a domain for this to happen? What's the
simplest solution? I don't have to worry about users that need to login,
etc... Just whatever SQL Server needs to replicate. Can I make the SQL Servers
DCs? Any help or pointing me in the right direction would be greatly
appreciated!

Thanks
 
I would post this issue to the SQL newsgroups, as they are better source
regarding SQL server replication. You can install an SQL server on a DC, but
normaly it is better to install SQL server on a separate member server.

--
Regards

Matjaz Ladava, MCSE (NT4 & 2000), Windows MVP
(e-mail address removed)
http://ladava.com
 
Back
Top