Friday, March 9, 2012

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.

No comments:

Post a Comment