SQLServer2000 1053 error (service does not respond in time or control requests) Solution

Error 1053 is reported when SQLServer2000 is started today

The error is as follows:

Error 1053-(the service did not respond in time or control the request .), The operation is being performed on the MSSQLServer service.

I immediately went online to search for related information. I saw someone saying that this problem occurred after I changed the windows user password, but I didn't quite understand it, so I 'd like to summarize it myself.

Open "service" in management tools, find MSSQLSERVER, right-click Properties, select this account under login, and Click Browse. In advanced, click Search now and select the user you are logged on, enter the password of the user.

Success! You can continue using SQLServer!

If it is running on a server, we recommend that you use the permission of a common user to prevent Elevation of Privilege. For specific settings, refer to this article.

Sql2000 1053 error service does not respond promptly to start or control requests

Previously, SQL SERVER was good.
When I came to work, I found that the SQL SERVER service could not be started.

The prompt is as follows:
Error 1053-(the service did not respond promptly to the startup or control request .), The operation is being performed on the MSSQLServer service.

Machine environment:
WindowXP SP2
VC6.0
VS2003
VS2005
MSSQLSERVER 2000
SQLSERVER 2005

I tried to reinstall SQL Server N times while solving the problem.

On the MS website, the KB article is written by Alibaba Cloud.

Thank you for helping me find out what the problem is.

User reply: mvp ?..
Go directly to ms ..

User reply: I cannot reinstall SQL server. Have I cleared all the items for reinstallation?
User reply: SQL2000 cannot be installed

1. Delete the SQL installation directory under Program files (if important data exists, back up it first)
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.
HKEY_LOCAL_MACHINE \ System \ CurrentControlSet \ Services \ MSDTC.

3. Find the PendingFileRenameOperations project in 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 (do not delete all)
Before deleting the content, read the description.

5. The Sqlstp. log file in the Windows directory lists the operations performed by the installer and contains all the errors encountered during installation. By checking this file, you can find out where and why the installation 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 encountered by SQL-Server 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 starts as part of the SQL-Server2000 installer. The SQL-Server2000 installer installs MDAC2.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.


User reply: SQL server versions earlier than 2000, for example, 7.0 generally do not have multiple versions, only the standard version and the desktop version. If the user is not clear about the version to be installed, 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

User reply: if the above steps do not work, you can only reinstall the operating system, and then reinstall SQL server.
User reply: I will first try the uninstallation and installation methods upstairs
User reply: Have you modified the login password of the machine ?? What is your SQL statement in the region?
For example:
Control Panel-> governance tools-> services,
Select MSSQLSERVER, properties, and modify the current user name and password under the logon tab.
Reply: Done