SQL Server Server Installation Analysis_PHP Tutorial

Versions before sql server 2000, such as 7.0, generally do not have multiple versions, only the standard version and the desktop version. If the user is not sure which version to install, he can install it according to the installation prerequisite instructions on the installation. It is usually installed on the WIN2000 server version. Standard version, other systems can just install the desktop version; SQL Server 2000 installation problems are relatively big, common problems are as follows:
(1) Interruption when configuring the server.
(2) Interruption when registering ActiveX .
(3) Interrupt when the display reaches 100%.
(4) Prompt: command line option syntax error, type command /? for help, continue the installation, and finally appear when configuring the server: Unable to find dynamics Link SQLUNIRL.DLL to the specified path...
(5) The previously performed program created a pending file operation. You must restart before running the installation program.
(1)(2)(3) Solution Method:
Reminder: To avoid misoperation, back up the registry and database first. If you cannot enter SQL Server 2000, you can back up the files in the Program Files Microsoft SQL Server MSSQLData folder.
1. Uninstall SQL Server first (if it cannot be uninstalled, it will not work) It doesn’t matter, continue with 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_MACHINESOFTWAREMicrosoftMSSQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
4. Restart the system if necessary
5. Reinstall
In addition, you can also try the method of installing SQL Server 2000 in one step:
1: Insert the SQL Server 2000 CD.
2: In "Start"--"Run", type "F:x86setup.exe k=dbg" " (F stands for CD)
Note:
1. SQL Server 2000 versions 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 version, development version, evaluation version, MCDE of SQL Server 2000
II,
SQL Server 2000 each version and hardware requirements.
The solution to (4)
Because the path (full path) of the installation file contains Chinese characters.
For example, c:SQLSERVER Chinese Enterprise Edition
is changed to c:SQLSERVER
(5) Solution
a. Restart the machine and then install. If you find that the error still exists, please follow the steps below
b. Enter regedit
c in Start->Run. Go to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager location
d. Select the file -> Pour out and save
e. Right-click PendingFileRenameOperations in the right window, select Delete, and then confirm
f. Restart the installation and the problem is solved
-------- --------------------------------------------------