Analysis of SQL Server 2000 server installation (rpm)

2011-09-14  来源:本站原创  分类:Database  人气:127 

/ *
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 sql server 2000, for example, there is generally no more than one version 7.0, only the Standard Edition with the desktop version, users who do not know what the installed version, then install according to instructions on the installation prerequisites to install, usually tops the WIN2000 Server Edition Standard Edition, other systems can be installed on the desktop version; and SQL Server 2000 installation problems on relatively large, often see the following issues:
1, the configuration server interruption.
2, when the interrupt register ActiveX.
3, shows 100% of the time interrupt.
4, prompt: command line option syntax error, type command /? For help, to continue the installation, when the last appeared in the configuration server: can not find the dynamic link
SQLUNIRL.DLL in the specified path ... ...
5, before the proceedings created pending file operations, run the installation program, you must restart

Second, a solution of 1,2,3:

Reminder: To prevent this, back up the registry and the database can not enter the SQL Server 2000, you can backup C: Program Files \ Microsoft SQL Server \ MSSQL \ Data
(Default path) folder of files.
1), first uninstall SQL Server (uninstall does not matter can not afford to continue to operate below);
2), Microsoft SQL Server to delete the entire folder;
3) Run the registry, delete the following entries:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLSERVER
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SQLSERVERAGENT
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLSERVERADHELPER
HKEY_CURRENT_USER \ Software \ Microsoft \ Microsoft SQL Server
4), necessary to restart the system;
5), re-install.

It may also be trying to run a single-step method of installing SQL Server 2000:

1), into the SQL Server 2000 CD.
2), in the "Start" - "Run", type "F: \ x86 \ setup.exe k = dbg" (F is the CD-ROM)

Note:
1), different operating systems supported by SQL Server 2000 version (see: sql server 2000 version of the difference between the introduction and a text version of the query).
Windows 2000 Server SQL Server 2000 can install any version of
Windows 2000 Professional can only install of SQL Server 2000 Personal Edition, Developer Edition, Evaluation, MCDE
2), SQL Server 2000 and all versions of hardware and software requirements (see: SQL Server 2000 hardware and software installation requirements the article).

Third, a solution of 4

Because the installation files (full path), there are Chinese.
For example c: \ SQLSERVER Chinese Enterprise Edition \
Into c: \ SQLSERVER \

Fourth, a solution of 5

1), restart the machine, then install it, if we find there is this error, follow these steps;
2), in the Start - Run, type regedit;
3), to HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager position to find
PendingFileRenameOperations project, and delete it. This will clear the pending installation of the project.
4), select File - poured out, to save;
5), in the right window, right-click PendingFileRenameOperations, select Delete, and confirm;
6), restart the installation, problem-solving

Fifth, if the problem persists, try the first repair the operating system:

Command prompt, execute: sfc / scannow.

A last resort: for Windows 2000 and SQL Server 2000 installation disk installation disk, and sometimes cause of the problem is very strange, someone had to replace a power supply to solve the problem.

1), uninstall your SQL Server 2000, when necessary, delete the Program Files \ Microsoft SQL Server folder;
2), open the registry;
In the "Start" - "Run" type "regedit"
3) Click to open the following order;
+ HKEY_LOCAL_MACHINE
+ SOFTWART
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ ExceptionComponents
4), the ExceptionComponents delete all folders below;
If {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
5) restart;
6), re-install SQL Server 2000.

Six other shows

1), Windows directory Sqlstp.log file that lists the operations performed by the installer for more information and contains all the errors encountered during installation.
By examining the file, you can learn more about where setup fails and why.

2), SQL installation error message when 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 the SQL-Server SQL-Server when error encountered, this information can help you gain the failure.

3), need to check the other components of Microsoft Data Access Components (MDAC) setup, SQL-Server2000 install it as part of the process started.
SQL-Server2000 installation program will install MDAC2.6. The MDAC setup creates a separate log named Dasetup.log file; you can view the log file and make sure that MDAC
No problems installing the program.

相关文章
  • 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

  • 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 server to delete registered 2010-05-22

    SQL Server 2000 server to delete registered In SQL Server 2000, we must remove a server connection, click the right time to pause for a long time to respond will be stuck Failed, and now the Internet search found a way to connect the server to delete

  • 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

  • Link 64-bit 32-bit SQL Server 2005 SQL Server 2000 server 2010-09-21

    Problem Description: Create a linked server successfully, but the Times to execute the query the following error: Linked server "10.1.0.100" The OLE DB provider "SQLNCLI10" returned message "Unspecified error". Linked server

  • 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

  • 让 SQL Sever 2000 支持 2GB 以上的物理内存 2014-08-30

    随着公司业务平台不断扩大,原先数据库服务器上 2GB 的物理内存已显得较为吃紧.前段时间,一狠心,在 DELL 下了一个 PowerEdge 2950 架构的单,直接上到 4GB. 数据库服务器最在意的事情就是数据存储的安全可靠.为此我订购了四块 SAS 硬盘,其中一块做系统盘,其余三块组成一个 RAID5 阵列.这机器成本不算低了,好歹性能也跟上去了,于是日子就这么继续-- 最近发现服务器的物理内存占用情况比较有意思.无论我何时连上去看,物理内存占用量都在 1.5GB 至 1.75GB 左右,

  • SQL Server 2000 installation diagram 2011-07-29

    Version differences There are four versions of SQL Server 2000: Enterprise / Standard Edition / Personal Edition / Enterprise Edition Developer Edition and Standard Edition operating system needs to be installed on the server, Such as Windows NT Serv

  • 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

  • sql server 2000 installation of Times "pending file operation" error 2010-10-29

    Install sql server 2000 will often prompt: "Before the installation of a program already installed on your computer to create a pending file operations. Run the installer must restart your computer before!" Delete HKEY_LOCAL_MACHINE \ SYSTEM \ C

  • 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

  • Times sql server 2000 installation "file pending operation" error 2010-10-29

    Sql server 2000 installation often prompts: "In the past a program installed on your computer in your installation created pending file operations. Before running the installer must restart your computer!" Delete HKEY_LOCAL_MACHINE \ SYSTEM \ Cu

  • The version of SQL Server 2000 2011-04-24

    SQL Server 2000 is divided into the following versions: (1) Enterprise Edition This version is the most complete functionality of each version, the most powerful one, the number of concurrent users is no limit in theory, the database capacity of up t

  • 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

  • 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

  • JSP to connect SQL Server 2000 system configuration details 2010-07-14

    To SUN official site (http://java.sun.com) to download J2SDK installation file: j2sdk-1_4_2_04-windows-i586-p.exe, After the download is installed J2SDK; installed after setting the environment variable: My computer --- properties --- Advanced --- En

  • 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

  • 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 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