SQL Server Installation Analysis

Source: Internet
Author: User
Tags microsoft website
For SQL Server versions earlier than 2000, for example, 7.0 generally 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 first back up the registry and database to SQL Server 2000. You can back up files in the program files/Microsoft SQL Server/MSSQL/data folder.
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_USER/software/Microsoft SQL Server
HKEY_LOCAL_MACHINE/software/Microsoft SQL Server
HKEY_LOCAL_MACHINE/software/Microsoft/MSSQLServer
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: In "start" -- "run" type "F:/x86/setup.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. Go to the HKEY_LOCAL_MACHINE/system/CurrentControlSet/control/Session 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.
-------------------------------------------------------
If the problem persists, try to fix the operating system first.

Run the following command prompt:
SFC/scannow

Last method: Change the Windows 2000 installation disk and SQL Server2000 installation disk.
Sometimes the cause of the problem is very strange. Someone once changed a power supply to solve the problem.

1. Uninstall your SQL Server 2000 and delete the program files/Microsoft SQL Server folder if necessary.
2 open the Registry
In "start" -- "run", type "Regedit"
3. Click to open in the following order
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
4. delete all the folders under predictioncomponents!
For example, {60bff50d-fb2c-4498-a577-c9548c390bb9}
{60bff50d-fb2c-4498-a577-c9548c390bb9}
{60bff50d-fb2c-4498-a577-c9548c390bb9}
{60bff50d-fb2c-4498-a577-c9548c390bb9}
6 restart:
7. Re-Install SQL Server 2000

XP + SP2 Problems
1. For WINXP + SP2 systems, you must install SQL Server SP3 (service package Patch 3). If you have already installed it, you must install it again.
SP3 can be downloaded free of charge on the Microsoft website. The Chinese version address is as follows:
SQL Server 2000 Service Pack 3A
Http://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2ksp3.exe
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.