Article ID: 816499
If you install SQL Server Desktop Engine (also known as MSDE 2000), Setup may fail, and you may receive the following error message:
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information
This problem may occur if the new MSDE instance name is the same as the previously removed MSDE instance name, and the data files of the previous MSDE instance still exist in the Data folder.
To work around this problem, use one of the following methods.
Method 1: Move the Previous MSDE Data FolderTo do so, follow these steps:
Method 2 : Change the Data Folder LocationSet the location of the Data folder to a location that is different from the location that you specified in the previous installation. You can specifiy the location of the Data folder for the new instance of the MSDE by using startup parameters. To do so, perform one of the following tasks:
Method 3: Manually Remove the Previous Instance of MSDEWhen you remove the MSDE instance by using the Add/Remove Programs tool, the Data folder that corresponds to the MSDE instance are not removed. To make sure that previous instance of the MSDE is completely removed, manually remove the MSDE instance.
For additional information about how to manually remove MSDE, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/320873/EN-US/ )HOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2.0) Instance
If you remove a named instance of MSDE by using the Add/Remove Programs tool, the data files of that instance of MSDE are not removed. When you install an instance of MSDE that has the same name and Data folder path as the previous instance of MSDE, the MSDE installer does not create the system databases for the new instance of MSDE because system databases exist in the specified Data folder.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/302409/EN-US/ )FIX: Unable to Connect to SQL Server 2000 When Certificate Authority Name Is the Same As the Host Name of the Windows 2000 Computer
(http://support.microsoft.com/kb/275307/EN-US/ )BUG: Installation of SQL Server 2000 Desktop Engine Fails on Computers That Already Have SQL Server 7.0 Tools Installed
(http://support.microsoft.com/kb/299351/EN-US/ )BUG: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2 Installed
Article ID: 816499 - Last Review: June 20, 2014 - Revision: 2.0
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.