Correcting a failed installation of MSDE 2000
Overview
Note: This Technical Note includes instructions for making changes to the Windows registry. It is recommended that you make a backup of your Windows registry before modifying it. Incorrectly modifying the registry can cause Windows or Windows applications to fail.
Express Software Manager 7.x stores data in a SQL Server database. Setup detects the presence of SQL Server and will offer to install MSDE 2000, a run-time version of SQL Server 2000, if full SQL Server is not present. This is most often the case when evaluating Express Software Manager. If the MSDE installation fails, Express Software Manager can not run properly. Follow the steps below to troubleshoot a failed MSDE installation.
Common failures
Step 1: Determine if File and Print Sharing is enabled
File and Print Sharing must be enabled on the Express Administrative Console workstation in order for MSDE to successfully install.
If File and Print Sharing was not enabled, enable it and reinstall Express Software Manager.
Note: For details on how to determine if File and Print Sharing is enabled, see How to Tell if File and Print Sharing is Enabled, below.
Step 2: Determine if SQL Client Tools are installed
MSDE will not install if SQL Client Tools are installed. If SQL Client Tools are installed, uninstall the tools before going on to Step 3.
Step 3: Remove SQL-related registry entries
Once the MSDE installation fails, registry entries left behind will cause additional install failures. Delete the MSDE registry entries before reinstalling Express Software Manager.
Update the registry by following these instructions:
- Remove Microsoft SQL Server Desktop Engine from Add/Remove Programs if it is listed as a currently installed program.
- Run Regedt32.exe to modify the registry. (Be sure the View is set to Tree and Data.)
- Remove any of the following registry keys you find:
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLSERVER
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQL Redist
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\Exception Components
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
- Delete the following hive if it exists on any drives:
C:\Program Files\Microsoft SQL Server
- Restart the workstation.
Step 4: Update Microsoft Data Access Component (MDAC) drivers
Some old MDAC drivers contribute to the failure of the MSDE installation. Download the latest MDAC drivers from Microsoft and follow the installation instructions:
http://http://msdn.microsoft.com/data/downloads/updates/default.aspx
Restart the Administrative Console workstation after updating the MDAC drivers.
Step 5: Reinstall Express Software Manager
Disable any anti-virus software you have running, and reinstall Express Software Manager.
Note: If the installation gives you an option to "Repair" the installation, select this. If you do not get the "Repair" option, do a complete installation.
Continuing MSDE Installation Failures
If you have followed the above steps and are still unable to install MSDE on the Administrative Console workstation, email all the log files located in C:\Program Files\Express Metrix\7.0\Logs to:
support@expressmetrix.com
How to Tell if File and Print Sharing is Enabled
How to tell if File and Print Sharing is enabled in Windows 2000- Right-click on the My Network Places desktop icon and select Properties
or
from the Start menu, choose Settings and Network and Dial-up Connections. - Right-click on Local Area Connection and choose Properties.
- In the box labeled "Components checked are used by this connection:" verify that File and Printer Sharing for Microsoft Networks is listed and selected.
If File and Printer Sharing for Microsoft Networks is not listed:
- Click Install.
- Select Service.
- Click Add and choose "File and Printer Sharing for Microsoft Networks".
How to tell if File and Print Sharing is enabled in Windows XP- From the Start menu, choose Settings and Network and Dial-up Connections.
- Right-click on Local Area Connection and choose Properties.
- In the box labeled "This connection uses the following Items:" verify that File and Printer Sharing for Microsoft Networks is listed and selected.
If File and Printer Sharing for Microsoft Networks is not listed:
- Click Install.
- Select Service.
- Click Add and choose "File and Printer Sharing for Microsoft Networks".