BACKTRACK Migration Issue – Duplicate Security Groups – BACKTRACK Problem

Summary

This article explains a BACKTRACK problem that complicates migration by creating duplicate records, and details how to resolve the issue.

Symptoms

Duplicate records appear for each security group.

Explanation

In migrations from older BACKTRACK versions, (v6 or earlier) we often see duplicate records created for each Security Group in BACKTRACK. This will trigger errors every time BACKTRACK needs to access the user information.

Solution

The duplicates need to be removed. Since this duplicate is a duplication of the key field (Security Group name), SQL Management Studio IS NOT an effective way to remove it.

A better approach is to create two new groups (e.g. Administrator1 and Everyone1) and then delete the old groups (e.g. Administrator and Everyone). When the old ones are deleted, this will force BACKTRACK to move all the users assigned to the old Security Group to the new one.

Additional Comments

Enter additional comments here

Author


Was this article helpful?

Related Articles