To rebuild the SQL Server registry entries, open a command prompt. The following commands will run the Setup program to rebuild the Registry.
The options to the Setup program are case-sensitive and must be typed exactly as shown. Also, a space must be on both sides of the equal sign (=). This example assumes that SQL Server version 6.5 was installed on drive C:.
cd \mssql\binn
setup /t RegistryRebuild = On
Note You can use = On or = True for the setup line.
You now must answer the questions exactly as you did during installation. The Setup program will reinsert all of the entries into the Registry but will not install or change any files.
If SQL Server was set up to use integrated security, you will need to re-add all of the users and groups by using the SQL Security Manager. You should re-add all of the groups and users that you had previously added. The SQL Security Manager will recognize that the users already exist in SQL Server and will not modify SQL Server but will go ahead and add the necessary security entries in Windows NT.
Note If you reinstalled Windows NT because you were changing the domain for an Advanced Server, you will need to delete and re-add the users in SQL Server because the default domain name has changed and will cause the user name mapping to fail.