Quick question about security and MS SQL 2000

OK, we have a couple of MS SQL 2000 servers running in a Win2k AD domain.

Both machines are using mixed mode security, the issue appears to be this.

If I go into AD and change a groups name that has been granted access to
the SQL server, it doesn't seem to pick up on the name change.

I also can't add the new name to the SQL server, because of a conflict of a
SID.

So how do I get the MS SQL server to refresh the names of the native NT
groups that have been granted access, then have the names changed ??I think you need to drop the old name and add the new one. Why are you doing this? Experimenting?|||Its not uncommon to have a native AD Security group renamed to match
a changed "department" name lets say.

SQL 2000 doesn't seem to see the name change in AD, where is this info stored in
the SQL server ?? is there a SP to refresh the cache or this table ?|||I'd say changing a department name should result in a change of an OU, not a group. But that's just me.

quick question about replication in SQL2000 standard

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
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

quick question about replication in SQL2000 standard

Hi,
Can we configure the SQL 2000 database replication between two SQL server in
stalled on win2k standalone servers(workgroup)? or must the servers be membe
r server in the same domain?
regards,
FrankYou 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