SQL Server Server Installation profiling

SQL Server 2000 Previous versions, such as 7.0 generally do not exist multiple versions, only the standard version and desktop version, if the user is not clear what version of the installation, can be installed on the installation prerequisite instructions to install, generally in the WIN2000 server version of the standard version, other systems installed desktop version can be While the SQL Server 2000 installation problem is relatively large, the common problems are as follows:

(1) Interrupt when configuring the server.

(2) interrupt when registering ActiveX.

(3) display to 100% when interrupted.

(4) Hint: Command line option syntax error, type command/? For help, continue with the installation, and finally when configuring the server: Unable to find dynamic link SQLUNIRL.DLL to the specified path ...

(5) A previous program created a pending file operation and must be restarted before running the installer

(1) (2) (3) Solution:

Reminder: To avoid misoperation, back up the registry and database before SQL Server 2000, you can back up the files in the Program Files\Microsoft SQL Server\MSSQL\Data folder.

1, the first uninstall SQL Server (Uninstall does not drop does not matter, continue the following operation)

2, delete the entire Microsoft SQL Server folder.

3, run the registry, delete the following:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

4. Reboot the system if needed

5, reinstall

Alternatively, you can try to run the method of installing SQL Server 2000 one step at a while:

1: Put in the SQL Server 2000 CD.

2: At "Start"--"Run" type "F:\x86\setup.exe k=dbg" (F is disc)

Attention:

One, the version of SQL Server 2000 supported by different operating systems, and the requirements for hardware.

Windows Server can install any version of SQL Server 2000.

Windows Professional can only install the personal, development, evaluation, MCDE, SQL Server 2000 version

Two

SQL Server 2000 versions and the requirements for hardware.

(4) Solutions

Because the path to the installation file (full path) has Chinese.

For example C:\SQLSERVER Chinese Enterprise Edition \

Change into c:\SQLSERVER\