SQL Server installation analysis. For versions earlier than sqlserver2000, such as 7.0, there are generally no multiple versions. only the standard edition and the Desktop Edition are available. if you do not know what version to install, you can install SQL server versions earlier than SQL server 2000 as required. for example, MySQL 7.0 does not have multiple versions. only the standard version and the desktop version are available. if you do not know what version to install, you can install it according to the installation prerequisites. Generally, the standard edition is installed on the WIN2000 Server Edition, and the desktop edition can be installed on other systems. However, the installation of SQL Server 2000 is a big problem, frequently asked questions are as follows:
(1) server configuration is interrupted.
(2) ActiveX registration is interrupted.
(3) interrupted when 100% is displayed.
(4) prompt: command line option syntax error, type command /? For help, continue the installation, and finally appear when configuring the server: The Dynamic Link SQLUNIRL. DLL cannot be found in the specified path ......
(5) previously, the program created a pending file. before running the installer, you must restart it.
(1) (2) (3) solution:
Reminder: To avoid misoperation, you can back up the files in the Program FilesMicrosoft SQL ServerMSSQLData folder before backing up the registry and database to SQL Server 2000.
1. uninstall SQL Server first (it does not matter if it cannot be detached. continue the following operations)
2. delete the entire Microsoft SQL Server folder.
3. run the registry and delete the following items:
HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
4. restart the system if necessary
5. reinstall
You can also try to install SQL Server 2000 in one step:
1: put the SQL Server 2000 CD.
2: at "start" -- "run", type "F: x86setup.exe k = dbg" (F is a CD)
Note:
1. SQL Server 2000 supported by different operating systems and hardware requirements.
Windows 2000 Server can install any version of SQL Server 2000.
Windows 2000 Professional can only install the Personal Edition, development edition, evaluation edition, and MCDE of SQL Server 2000
II,
SQL Server 2000 versions and hardware requirements.
(4) solution
Because the installation file path (full path) contains Chinese characters.
For example, c: SQLSERVER Chinese Enterprise Edition
Change to c: SQLSERVER
(5) solution
A. restart the machine and install it again. if the error persists, follow these steps:
B. enter regedit in Start-> Running
C. to the HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager location
D. Select File-> inverted, save
E. right-click PendingFileRenameOperations in the right window, select Delete, and then confirm
F. restart the installation and solve the problem.
-------------------------------------------------------
Http://www.bkjia.com/PHPjc/631229.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/631229.htmlTechArticlesql server 2000 versions earlier, such as 7.0 generally does not have more than one version, only the standard version with the desktop version, if you do not know what version to install, you can follow the installation prerequisites on installation...
