Synchronizing a database with Active Directory changes (Model Explorer)
You should synchronize SQL Server with Active Directory following any changes to users or groups. In SQL Server, group memberships are cached on the database. You should update the database with the latest changes to users and groups in Active Directory. For example: a user under an AD group with principal login can still have access to a database after the user is removed from the group in Active Directory. In order to update the database with the latest permissions, use the following commands.