Solution to installation failure after sql2000 is uninstalled and re-installed

Source: Internet
Author: User
Tags sql server driver odbc sql server driver

1. Delete the SQL installation directory under Program files (back up important data first)
C: Program FilesMicrosoft SQL Server80Tools.
C: Program FilesMicrosoft SQL ServerMSSQL.
2. Delete related information in the registry:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer.
HKEY_LOCAL_MACHINESystemCurrentControlSetServicesMSDTC.
3. Find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager and delete it. In this way, you can clear the temporary installation project.
4. HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionsetup
Delete predictioncomponents
There may be a lot of content in this project, and this method can be used only when the above methods are not feasible (Be sure not to delete all)
Before deleting the content, read the description.
5. The Sqlstp. log file in the Windows directory lists detailed information about the operations performed by the installer and contains all errors encountered during installation. By checking this file, you can learn in detail where the installation fails and why it fails.
6. The error message during SQL installation is stored in a log file named Errorlog. By default, this file is stored in the Program FilesMicrosoft SQL ServerMssqlLog directory. This error log contains the errors encountered by SQL-Server when the installer tries to start SQL-Server. This information can help you thoroughly check the cause of the error.
7. Another component to be checked is the Microsoft Data Access Component (MDAC) Installer which starts as part of the SQL-Server2000 installer. The SQL-Server2000 installer installs MDAC2.6. The MDAC installer creates a separate log file named Dasetup. log. You can view this log file and ensure that the MDAC installer has no problems.
Problem 2: During installation, the system prompts that the specified file cannot be read, which is probably caused by abnormal network connection. correct the problem and restart the installer. File: Q: personalx86setup .. binn es1033sqlmmc. rll
Solution: if there is a problem with the installer, we recommend that you change the installer.
Question 3: the installation prompt is to find the SQL Installation Log, which is in the C: windowssqlstp directory. The general network error log is displayed when it is opened, as shown below:
-------------------------------------------
Driver = {SQL server}; server = soyo; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (WrapperRead ()).
Driver = {SQL server}; server = soyo; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (WrapperRead ()).
Driver = {SQL server}; server = soyo; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionR

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.