sql server 2000 install hangs solution

2010-12-03  来源:本站原创  分类:Database  人气:90 

SQL2000 can not install the solution

If you have previously installed SQL SERVER 2000, according to the following steps:

1, under the Program files to delete the SQL installation directory (here, if you have important data, back up)

C: \ Program Files \ Microsoft SQL Server \ 80 \ Tools.
C: \ Program Files \ Microsoft SQL Server \ MSSQL.

2, to delete information in the registry:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer.
HKEY_LOCAL_MACHINE \ System \ CurrentControlSet \ Services \ MSDTC.

3, HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager found PendingFileRenameOperations project, and delete it. This will clear the pending project installation

4, HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ setup
Delete ExceptionComponents

The content of this item may be many, not only in the above case of several ways, using this method (note do not remove all)

Look under the contents before deleting the content description

5, Windows directory Sqlstp.log file that lists the actions performed by the installation program details, and includes all errors encountered during installation.
By examining the file, you can learn more about where setup fails and why.

6, SQL installation Error information is stored in a log file called Errorlog, by default the file is located in Program Files \ Microsoft SQL Server \ Mssql \ Log directory.
The error log contains the installation program attempts to start SQL Server when SQL Server encounters an error, this information can help you gain the failure.

7, need to check the other components of Microsoft Data Access Components (MDAC) setup, SQL Server 2000 installed as part of the process started.
SQL Server 2000 Setup program will install MDAC 2.6. The MDAC setup creates a separate log named Dasetup.log file; you can view the log file and make sure that the MDAC setup no problems.

相关文章
  • sql server 2000 install hangs solution 2010-12-03

    SQL2000 can not install the solution If you have previously installed SQL SERVER 2000, according to the following steps: 1, under the Program files to delete the SQL installation directory (here, if you have important data, back up) C: \ Program File

  • Prompted to install SQL Server 2000 solution file error hangs 2010-05-13

    Prompted to install SQL Server 2000 solution file hang error when prompted to install SQL SERVER 2000: "In the past a program installation created pending the installation files on the computer operation. Before running Setup must restart your comput

  • Install sql server 2000: the previous installation of a program already installed on your computer create a pending file 2010-05-05

    Yesterday, install SQL Server 2000, because the local backup file after trying to install, no response, it is estimated that when the virus destroyed the sql compressed package integrity; so from the original CD to install MSSQL, but Tip: When hangin

  • Win7 64-bit SQL Server 2000 operating system installation issues encountered in [solution] 2011-01-08

    Win7 64-bit SQL Server 2000 operating system installation issues encountered] [intelligent software solutions workshop CLSW Chen Liang (buttoning a shirt: 40375363) http://clsw.blogcn.com/diary, 35403512.shtml 1,64-bit operating systems are not compa

  • Remote connections sql server 2000 server solution 2010-03-18

    One can see ping ping the server IP communications. This fact is to look at and remote sql server 2000 server, the physical connection exists. If not, please check the network, view the configuration, of course, make sure that the remote sql server 2

  • SQL server 2000 tips "can not execute the query, because some file is missing or not registered" solution 2010-07-20

    Symptoms: In SQL server 2000, open the table view of data, suggested that it "can not execute the query, because some file is missing or not registered" Using Query Analyzer you can view the data, reinstall the sql2000 useless Solution: Register

  • JDBC with SQL SERVER 2000 1433 port error solution 2011-06-01

    Transfer from (binyao02123202 column): http://blog.csdn.net/binyao02123202/archive/2010/11/04/5986744.aspx If you test the connection when the SQL Server 2000 JDBC Connection Error Error establishing socket. Please refer to the following: Check with

  • How to install SQL server 2000 SP4 patch 2011-07-29

    How to install SQL server 2000 SP4 patch 2009-04-11 14:14 First, download a personal version of SQL Server 2000 installation up, reboot after the installation a bit, re-tested finish, SQL is normally used. Then in MicroSoft's official website (rememb

  • SQL Server 2000 Enterprise Edition log shipping solution temperature equipment 2011-02-20

    'SQL Server 2000 Enterprise Edition' log shipping solution temperature equipment Principle 1 In SQL Server 2000 Enterprise Edition, you can use "log shipping" will be continuously available transaction logs from one database to another. Uninterr

  • SQL code to connect remote sql server 2000 server solution 2011-02-20

    Ping the server IP to see whether the ping. This fact is to look at and remote sql server 2000 server physical connection exists. If not, please check your network, view the configuration, of course, have to ensure that the remote sql server 2000 ser

  • Microsoft SQL Server 2000 Enterprise Edition can not install 2011-07-05

    Microsoft SQL Server 2000 Enterprise Edition can only be installed in the Server operating system, can not be installed on WINDOWS XP. You can install Microsoft SQL Server 2000 Personal Edition, the overall functionality with Microsoft SQL Server 200

  • Sql Server 2000 Enterprise Manager can not open (MMC) solution 2010-08-03

    Open the Sql Server 2000 Enterprise Manager, display the error status: MMC can not open the file C: \ Program Files \ Microsoft SQL Server \ 80 \ Tools \ BINN \ SQL Server Enterprise Manager.MSC. Analysis: See the file exists or damage. Regardless of

  • win 7 after installing sql server 2000 Enterprise Manager can not create tables 2010-10-01

    Fighting At two in the morning, to finally get! ~ wait was worth it expensive. . Tired, do not speak nonsense, the installation started one. Source (1) SQL Server 2000 Personal Edition Simplified Chinese Version (Download: http://www.duote.com/soft/1

  • JDBC connection using a named instance of SQL Server 2000 (Named Instance) 2010-11-25

    JDBC connection using a named instance of SQL Server 2000 (Named Instance) 2006-09-11 22:09 by Bing Ge, 2561 visits, network picking, collection , editing Until recently, free to love playing with a number of gadgets, the first time more interested i

  • [Turn] to manually completely remove SQL Server 2000 is very simple. 2011-04-22

    This article is mainly to introduce completely manually remove SQL Server 2000 hands-on process, a few days before safe SQL Server 2000, do not know what stepped out of a number of issues, SP4 has not hit, and N many procedures have to be SP4 run, af

  • Analysis of SQL Server 2000 server installation (rpm) 2011-09-14

    / * Title: SQL Server 2000 server installation analysis Author: Author: Aisingiorro Yuk Wah (eighteen years of wind and rain, snow lotus flowers keep the tip too) Time :2008 -05-05 Location: Shenzhen, Guangdong * / First, note previous versions of sq

  • java to connect SQL Server 2000 database 2009-11-16

    Steps: 1. Download the JDBC Driver. Enter http://www.microsoft.com/downloads/en/results.aspx?displaylang=en&freeText=sql + server +2000 + driver + for + jdbc Select SQL Server 2000 Driver for JDBC SP3. Download setup.exe (2.3MB) 2. To install the dow

  • java database connectivity sql server 2000 2010-03-20

    1. Make sure sql server 2000 is a sp4 (at least sp3) L have packages available at microsoft's official web down to the Can use the following ways to view MSSQL version: Open Enterprise Manager - "Tools -> SQL Query Analyzer -" Help - "Wi

  • After installing 360 anti-virus installed sql server 2000 report pending error 2010-03-17

    When you install sqlserver2000 reported a pending issue, depressed for a long time. To solve the problem now to share, we want a little help After installing 360 anti-virus in the registry will have the following items + HKEY_LOCAL_MACHINE \ SYSTEM \

  • SQL Server 2000 compared with 2005 2010-06-26

    Auto ID: set the field type: int, then the column properties (a logo) election, the identity seed S 1. Use varchar (max) instead of text. The maximum length of varchar is 8000, but the varchar (max) can store up to 2G of data, so the effect is equiva