Showing posts with label _nextpart_000_0036_01c51ffd. Show all posts
Showing posts with label _nextpart_000_0036_01c51ffd. Show all posts

Friday, March 9, 2012

quick question about replication in SQL2000 standard

This is a multi-part message in MIME format.
--=_NextPart_000_0036_01C51FFD.3E5FF470
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Can we configure the SQL 2000 database replication between two SQL = server installed on win2k standalone servers(workgroup)? or must the = servers be member server in the same domain?
regards,
Frank
--=_NextPart_000_0036_01C51FFD.3E5FF470
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,

Can we configure the SQL 2000 database = replication between two SQL server installed on win2k standalone servers(workgroup)? = or must the servers be member server in the same domain?

regards,
Frank


--=_NextPart_000_0036_01C51FFD.3E5FF470--You can, but you will need to be running in Mixed-Mode Authentication and
you will have to use SQL Server Logins.
Another option is to use Local Windows accounts, which you will have to
create on both servers, garauntee the same SIDs, names, and passwords, and
always keep these synchronized. This is a more complex strategy but can
work.
Sincerely,
Anthony Thomas
"Frank" <signup0702@.sina.com> wrote in message
news:uNQpao7HFHA.3196@.TK2MSFTNGP15.phx.gbl...
Hi,
Can we configure the SQL 2000 database replication between two SQL server
installed on win2k standalone servers(workgroup)? or must the servers be
member server in the same domain?
regards,
Frank