Step 2 - Create UserSidTracking Database
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
Log on to RES-DC.fabrikam.resource.net as Administrator
Click Start, click All Programs, click Microsoft SQL Server 2008, and click SQL Server Management Studio.
On the Connect to Server dialog box, under Server Type: select Database Engine.
On the Connect to Server dialog box, under Server name: select RES-DC.
Do not select RES-DC\MS_ADMT. This is instance is used by the Active Directory Migration Tool. You should just select RES-DC.
On the Connect to Server dialog box, under Authentication: select Windows Authentication.
At the top, click New Query. This will bring up a new query pane in the center of Microsoft SQL Server Management Studio.
Copy the code from Appendix A – UserSidTracking database and paste it into the center.
Click Execute! The pane will split and you will see the following message – Command(s) completed successfully.
Close Microsoft SQL Server Management Studio.