SQL 2000 and group names

Posted by Nasa on Server Fault See other posts from Server Fault or by Nasa
Published on 2009-10-15T15:19:53Z Indexed on 2010/04/10 11:03 UTC
Read the original article Hit count: 353

Filed under:
|
|

I have a SQL 2000 server which has databases, under user section of the database object, I have some NT 4.0 groups. These groups were migrated over to Active Directory some time ago using ADMT with SID history. The original source domain groups have since been deleted. The access shown is olddomain\groupname. I don't know why, if they were ntfs permissions they would update automatically to target\groupname.

The users in the AD domain still have access to the database as they are a member of the migrated group (Target\groupname). I was wondering

1) Why does the old group (source\groupname) show up as it doesn't exist anymore. But access is still granted to the target group? 2) Is there any easy way to update the group name from source\groupname to target\groupname?

Thanks for any help.

© Server Fault or respective owner

Related posts about sql-server-2000

Related posts about admt