Step 2 - Create UserSidTracking Database

  • Article

Applies To: Windows Server 2008, Windows Server 2008 R2

In this step we will be creating the UserSidTracking database. This database is used to track the users that have had their sIDHistory attribute successfully populated.

Creating the UserSidTracking Database

The following steps show how to create the UserSidTracking database.

To create the UserSidTracking database

  1. Log on to RES-DC.fabrikam.resource.net as Administrator

  2. Click Start, click All Programs, click Microsoft SQL Server 2008, and click SQL Server Management Studio.

  3. On the Connect to Server dialog box, under Server Type: select Database Engine.

  4. On the Connect to Server dialog box, under Server name: select RES-DC.

Note

Do not select RES-DC\MS_ADMT. This is instance is used by the Active Directory Migration Tool. You should just select RES-DC.

  1. On the Connect to Server dialog box, under Authentication: select Windows Authentication.

  2. Click Connect.

  3. At the top, click New Query. This will bring up a new query pane in the center of Microsoft SQL Server Management Studio.

  4. Copy the code from Appendix A – UserSidTracking database and paste it into the center.

  5. Click Execute! The pane will split and you will see the following message – Command(s) completed successfully.

  6. Close Microsoft SQL Server Management Studio.