Microsoft KB Archive/830477

= BUG: You cannot repair SQL Server 2000 Desktop Engine (Windows) by using the Add/Remove Programs tool =

Article ID: 830477

Article Last Modified on 2/13/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)

-



SYMPTOMS
When you try to repair your installation of Microsoft SQL Server Desktop Engine (Windows), the repair option is no longer available for this service in Add/Remove Programs tool.



RESOLUTION
To repair your installation of SQL Server Desktop Engine (Windows), follow these steps.

Note You must know the location of the original .msi file that was used for the installation. If you are not sure which .msi file was used, see the following article in the Microsoft Knowledge Base:

311762 INF: How to identify which MSI file was used for an existing MSDE installation

 Open a command prompt, and then locate the folder where the installation files for SQL Server Desktop Engine (Windows) are stored.  At the command prompt, type the following command, and then press ENTER: MSIEXEC.EXE REINSTALL=ALL REINSTALLMODE=OMUS /I relative path of sqlrun**.msi INSTANCENAME=Instance Name Note Put  in single quotation marks.   To only rebuild the master database of SQL Server 2000 Desktop Engine (Windows), type the following command, and then press ENTER: MSIEXEC.EXE REINSTALL=ALL REINSTALLMODE=AMUS /I relative path if sqlrun**.msi INSTANCENAME=Instance Name Note Put  in single quotation marks. 



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section of this article.

Keywords: kbbug kbprb KB830477

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.