SQL2000 Installation Problems)

SQL Server 2000 has a big installation problem, which is often seen as follows:

1. Q: The installer is suspended and the computer needs to be restarted.

Solution:Except the pendingfilerenameoperations subkeys In the HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager in the registry.

Cause:According to the name, HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager should store the snapshot of the current system session, while pendingfilerenameoperations records an unsuccessful file renaming operation, SQL Server may use this key value during installation and records operations on temporary files during installation. If SQL Server discovers this key value when the installation process starts, it considers that the previous installer is not complete, and thus rejects the installation process. In principle, any program that modifies this key value should delete this key value at the end or when the system restarts, however, if this operation is not performed for various reasons, SQL Server will naturally come to an incorrect conclusion.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2. Q:I would like to ask the prompt when I Install SQL Server2000 after I reinstall the system:In the past, a program was installed to create a suspended file on the computer. You must restart the computer before running the installation..After the registry operation, I have installed half of the server, but the prompt is: the installation program fails to configure the server. Refer to the server error log c: \ windowns \ sqlstp. Log

　　A:1. Delete the SQL installation directory under program files (back up important data first)

A:Because the installation file path (full path) contains Chinese characters, for example, C: \ sqlserver \, and changed to c: \ sqlserver \

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

5. Q: a suspended file has been created for a previously executed program. You must restart the installer before running it.

A: A. Restart the machine and install it again. If this error persists, follow these steps:
B. Enter Regedit in start-> running
C. 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.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

6,XP + SP2 problems; Enterprise Edition cannot be installed in Windows XP SP2 or other non-server operating systems

The SQL2000 Enterprise Edition is applicable to Windows 2000, and the 2003 and XP systems generally cannot be installed with the individual edition. Of course, if you have worked hard to download the Enterprise Edition, you cannot install it, are you very disappointed? This document describes how to install SQL2000 Enterprise Edition in XP for your reference ~

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

2. Go to the Enterprise Edition installation directory, go to the MSDE directory, and run Setup installation. This is the server component installer. Restart the system and you will find the server icon in the tray. After that, go to the Enterprise Edition installation program and follow the prompts to install it properly. Then, take out the installation disc of the SQL Server Edition and install the client tool directly (do not talk about it more? The simplest example is to directly click autorun.exe in the optical root directory. If you know that the system is not a server version during self-check, you will be prompted to install only the client tool. (Haha, I already have the server) I am still prompted that the server components cannot be installed, but it doesn't matter. We have already manually installed the server program. Open the Enterprise Manager and try connecting the SA user to see if the SA User Login fails? Because you have not been associated with a trusted SQL server connection. Fortunately, you only need to make a slight modification to the system registry. Enter Regedit at run to open the Registry Editor and find [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer ].
There is a key value loginmode. By default, the value is 1. Change the value to 2 and restart the computer. Start enterprise management and try again. Is it OK!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

7. Q: SQL2000 installed in win2003

A:Run the "... sql2000sp2 cannot be installed under win2003..." prompt to install SQL2000 in win2003. Click continue. After the installation is complete, set it to SP3 immediately. No problem!

This error occurs only during the installation process: the installation program fails to configure the server. Refer to the server error log and c: \ winnt \ sqlstp. log for more information. first, delete the installation directory and the Microsoft SQL Server folder under c: \ Program Files, and delete all information about Microsoft SQL Server under CURRENT_USER and LOCAL_MACHINE \ Software \ Microsoft, then 1 open the Registry
In "start" -- "run", type "Regedit"
2. Click to open in the following order
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
3. 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}
... 4 restart:
5. Re-Install SQL Server 2000 another comment on a blog: cause of the problem:
This is a SQL Server bug. getcomputername is used to obtain the name of a local computer. The client network library component (dbmslpcn. dll) converts the name to all uppercase letters. The server network library component (ssmslpcn. dll) retains the name returned. Installation fails when the Windows computer name contains both uppercase and lowercase letters or both lowercase letters. A general network error is prompted!
The solution is to change the computer name to uppercase!
I changed the name of my computer to uppercase, and then restarted. The network error problem just now was gone. But I am prompted to log on to sa failed. It is strange that I re-install the specified password with a blank password. How can I install the program and log on to the SA as well? Later I remembered that the purpose of uninstalling SQL Server was to keep my data, so I was lazy and did not delete the files in the data folder under the original SQL Server installation directory, master. MDF and master. LDF is in. In the past, the SQL server had a password. As a result, these two files are quickly deleted. Reinstall it again. OK! Installation successful. Summary:
1. In the future, the computer name must be capitalized to avoid unnecessary troubles. 2. Remember to delete master. MDF and master. LDF when you reinstall SQL Server. Note: My computer name is also in lowercase, but I did not change it to uppercase, but I changed the user name to uppercase during SQL installation, delete the folder and clear the registry according to the above practice, so I think the above statement is worth exploring! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~8. Q: An error occurred while installing SQL Server 2000. The dynamic link library sqlunirl. dll cannot be found.The Installation File is certainly correct. It has been installed before and can be used. The host has been installed with SQL Server 2000 and can be used normally. it is only today that it is suddenly unable to connect to the local database and is intended to be reinstalled, I deleted the ms SQL directory in program files and re-installed the SQL. The result is prompted at the last step, and the configuration cannot be completed. Later, I deleted some SQL Server Information in the Registry (with a backup note table). When I installed it again, this prompt appeared. Worse, the backup registry cannot be restored.A:When the MDAC component fails to be installed, try to repair or reinstall Microsoft Office. When you want to reinstall SQL Server, you can delete the Program Files \ Microsoft SQL Server folder, when a dynamic link file cannot be found, try to find the file in the installation file of SQL Server, copy the file to the system and system32 folders in the system directory. (when this error message is displayed, the system prompts which folders do not contain this file ). When the installation program fails to configure the server, try to solve it
This error message can be found in the system directory. For example, if my system is Win2000, the file is in c: \ winnt \ sqlstp. log ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~9. Q: "failed to configure the server. Refer to the System Log description" and return the installation progress bar.

　　A:Cause: the system configuration does not meet the Microsoft SQL Server Desktop Engine installation requirements.
Solution: MSDE 2000 requires Microsoft Internet Explorer 5.0 or later. The minimum installation is enough. Internet Explorer does not have to be the default browser.
(1) On the control panel, double-click "network connection ".
(2) In the "advanced" menu, click "Advanced Settings ".
(3) On the "adapter and binding" tab, confirm that "file and printer sharing for Microsoft Network" is selected ".
If any of the following security policies has been set to "installation prohibited", MSDE 2000 installation will fail: ● Windows XP Local Security Policy "device: Installation of unsigned drivers ".
● In Windows 2000, The Local Security Policy "Unsigned Non-driver installation operations" is applied ".
If the "installation prohibited" setting is used, you must change this setting to "continue by default" before installing MSDE 2000 ". If necessary, you can restore the policy to previous settings after installation.
"Installation prohibited" is not the default setting of these security policies.
To set these policies, perform the following operations:
1. on the "control panel", double-click "Administrative Tools ".
2. Double-click "Local Security Policy ".
3. Expand "local policy ".
Select "Security Options ".
Make sure that the following options in the right pane are set to "Default continue" before MSDE 2000 is installed ":
For Windows NT and Windows 2003: "device: install an unsigned driver ".
For Windows 2000: "Unsigned Non-driver installation operations ".
Delete the SQL Server Directory that has been installed before you reinstall it.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~

10. Q: "The specified Instance name is invalid"

　　　A:SQL Server is not deleted from the Add/delete program. Delete the installed sqlserver directory. It is also possible that your service cannot be started, resulting in installation failure!
Configure the service before re-installation!
1. Restart the following services: COM + system application, application management, ASP. NET State service, Distributed Transaction Coordinator, http ssl, Remote Procedure Call (RPC) Locator
Practice: Start-> Run-> services. MSC to the right and change its attribute
"Automatic" is already automatic, so don't change it. After the change, click Start service!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

11Q: When installing SQL Server, select start installation. The installation dialog box is invisible next time. Double-click setup again. The system displays "another installer is running" for a long time, the installer displays "no response" in the "Task Manager", and the process disappears. However, the process is still in the list. Your service is being configured.
　　　　A:1 open the Registry
In "start" -- "run", type "Regedit"
2. Click to open in the following order
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
3. 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}
.......
4 restart:
5. run SQL Server 2000 again and select modify instance.
6. Run SQL Server 2000 again. Select advanced to fix the registry.
Finally, we can. :) It does not stop when you start the server or install the configuration you selected.
Environment: win2000pro. Install SQL Server 2000 Enterprise Edition. Ntswitch is used.

Summary:

The specific problem should be solved. Generally, a network error occurs. The solution is to change the computer name to uppercase. Remember to delete the previous data file and solve it successfully. if there are more errors, find the problem and solve it. 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 strange. Someone has replaced a power supply to solve the problem.

 

C: \ Program Files \ Microsoft SQL Server \ 80 \ tools.
C: \ Program Files \ Microsoft SQL Server \ MSSQL.

2. Delete related information in the registry:

 

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer.
Find the pendingfilerenameoperations project in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSDTC 3: HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager and delete it. In this way, you can clear the temporary installation project

4: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ setup
Delete predictioncomponents

There may be a lot of content in this project, and this method can be used only when the above methods are not feasible (Be sure not to delete all)

Before deleting the content, read the description.

5. The sqlstp. log file in the Windows directory, which lists detailed information about the operations performed by the installer and contains all errors encountered during installation. By checking this file, you can learn in detail where the installation fails and why it fails.

6. The error message during SQL installation is stored in a log file named errorlog. By default, this file is stored in the Program Files \ Microsoft SQL Server \ MSSQL \ log directory. This error log contains the errors that SQL Server encounters when the installer tries to start SQL server. This information can help you thoroughly check the cause of the error.

7. Another component to be checked is the Microsoft Data Access Component (MDAC) Installer, Which is started as part of the SQL Server 2000 installer. The SQL Server 2000 installer installs MDAC 2.6. The MDAC installer creates a separate log file named dasetup. log. You can view this log file and ensure that the MDAC installer has no problems.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3. Question (1) server interruption during server configuration.

(2) ActiveX registration is interrupted.

(3) interrupted when 100% is displayed.

　　A: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. In "start" -- "run", type "F: \ x86 \ setup.exe K = dbg" (F is a CD)
[This command means that the installation of SQL Server 200098% in one step is not successful.
4. 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
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
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}
.......
4 restart:
5. Re-Install SQL Server 2000
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)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4. Q: Prompt: command line option syntax error, TYPE command /? For help,Continue the installation, and the following occurs when configuring the server: The Dynamic Link sqlunirl. dll cannot be found at the specified path ......