Skip to main content
We’ve updated our Terms of Service. A new AI Addendum clarifies how Stack Overflow utilizes AI interactions.
Remove 2000 tag
Link
LapTop006
  • 6.5k
  • 22
  • 26
Source Link
Nasa
  • 316
  • 1
  • 7

SQL 2000 and group names

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.