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
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;
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)
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;
4), the ExceptionComponents delete all folders below;
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.