PRB: Rebuildm.exe not Available After You Upgrade MSDE Edition to SQL Server 2000 (274390)

SYMPTOMS

When you upgrade from the SQL Server 2000 Desktop Engine to the SQL Server 2000 (Personal, Standard, or Enterprise editions), you are prompted to install additional components. If you select NO, and then complete the upgrade process, only the Server Network Utility and the Service Manager are installed as part of the client tools.

However, if you run the setup again and select the upgrade option and you then add all the components, the setup completes and all the other tools are installed except the Rebuild Master utility (Rebuildm.exe). Note that the Rebuildm.exe file does not exist in the following directory:

Program Files\Microsoft SQL Server\80\Tools\Binn

If you select YES during the initial upgrade to install the additional components, this problem does not occur.

WORKAROUND

Here are two ways to work around this problem:

Copy the following files from the SQL Server 2000 CD to your Program Files folder on the local system drive:
```
Rebuildm.exe  (From x86\binn\ to \Program Files\Microsoft SQL Server\80\Tools\binn\)

Rebuildm.rll  (From x86\binn\res\1033 to \Program Files\Microsoft SQL Server\80\Tools\binn\resources\1033)

Sqlsui.rll    (From x86\binn\res\1033 to \Program Files\Microsoft SQL Server\80\Tools\binn\resources\1033)

Sqlsui.dll    (From x86\binn\ to \Program Files\Microsoft SQL Server\80\Tools\binn\)
							
```
NOTE: When you run Rebuildm after you use this workaround, you must manually set the collation setting. Otherwise, Rebuildm may wait indefinitely with the progress bar looping. To avoid this, be sure to click Settings and select the original collation setting before you commit to running the rebuild master.

-or-
Install a new instance of SQL Server 2000, which installs all the tools in the tools folder. You can then remove it if you do not want to keep the instance.