SQL Server Server Installation profiling

server| Server

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\

(5) Solutions
A, restart the machine, and then install, if you find the error, please follow the steps below
b, enter regedit in the start-> run
C, to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager location
d, select the file-> pour out, save
E, in the right window right click PendingFileRenameOperations, select Delete, and then confirm
F, reboot installation, problem solving
-------------------------------------------------------
If the problem persists, try repairing the operating system first.

Execute at the command prompt:
Sfc/scannow

Last method: Change Windows 2000 Setup disk and SQL Server2000 installation disk
Sometimes the reason for the problem is strange, someone has replaced a power supply to solve the problem.

1 Uninstall your SQL Server 2000 first, delete Program Files\Microsoft SQL Server folder when necessary
2 opening Registry
At start--"Run" type "regedit"
3 Click Open in the following order
+ HKEY_LOCAL_MACHINE
+ Softwart
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ exceptioncomponents
4 Delete all the folders below Exceptioncomponents!
such as {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
6 reboot:
7 Reinstall SQL Server 2000

XP+SP2 issues
1.WINXP+SP2 Systems need to install SQL Server SP3 (Service Pack patch 3), which must be installed again if previously installed.
SP3 can be downloaded for free at the Microsoft website, with the Chinese version address as follows:
SQL Server Service Pack 3a
http:// Download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2ksp3.