SQLServer2000 1053 Error (service does not respond promptly or control request) solution _mssql

Starting today SQLServer2000 times 1053 Error

The error is as follows:

Error 1053 occurred-(the service did not respond or control the request in a timely manner.) , this service operation is being performed on the MSSQLServer service.

I immediately go online to find information, see someone said to change the Windows user password after the problem, but not very clear, so I want to sum up.

Open the management tool in the "services", find MSSQLServer, right key attributes, select this account under Login, then click to browse, in the advanced point immediately find, select the user you logged in, and finally enter the user's password.

Done! You can continue with SQL Server!

If it is running on the server, we recommend that you run with common user rights to prevent the right to be raised. The specific setting method, may refer to this article.

sql2000 1053 Error service does not respond to start or control requests in a timely manner

SQL Server was all right before that.
The notebook brought home on Chinese New Year didn't pay attention to how it happened. When you work, you find that the SQL Server service does not start

The prompts are as follows:
Error 1053 occurred-(the service did not respond to the start or control request in a timely manner.) , this service operation is being performed on the MSSQLServer service

Machine Environment:
WINDOWXP SP2
VC6.0
VS2003
VS2005
MSSQLServer 2000
SQL Server 2005

The reload SQL SERVER2000 that tried n times during the problem resolution

The KB article on Ms's website is written in unintelligible.

Thank you for helping me see what's wrong.

User reply: MVP?..
Go directly to Ms.

User reply: Reload SQL Server is not OK. Did you erase everything and reload it?
User reply: SQL2000 can not install the solution

1, the Program files under the SQL installation directory to delete (if there is important data, please back up first)
C:\Program Files\Microsoft SQL Server\80\Tools.
C:\Program Files\Microsoft SQL Server\MSSQL.

2, the relevant information in the registry delete:
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. This allows you to clear the installation pending items.

4, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup
Delete Exceptioncomponents

There may be a lot of content under this project, and use this method only if the above methods do not work (focus on not deleting all)
Read the contents before deleting the content

5, the Sqlstp.log file in the Windows directory that lists specific information about what the installer is doing and includes any errors encountered during installation. By examining the file, you can find out exactly where the installation failed and why it failed.

6. The error message for SQL installation is stored in a log file called Errorlog, which is located in the Program Files\Microsoft SQL Server\mssql\log directory by default. The error log contains errors that Sql-server encountered when the installer attempted to start Sql-server, which can help you drill down into the cause of the error.

7. Another component that needs to be checked is the Microsoft Data Access Component (MDAC) installer, which is started as part of the sql-server2000 Setup program. 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 does not cause problems.


Users reply: The previous version of SQL Server 2000, such as 7.0 generally does not exist in more than one version, only the standard version and desktop version, if the user is not clear what version, you can install on the installation prerequisite instructions installed, generally in the WIN2000 server version of the standard version, Other systems can be installed on the desktop, 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 that 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

Users reply: If you do not follow the above steps, you can only reload the operating system, and then reload SQL Server.
User reply: I first try the uninstall and installation method upstairs
User reply: Is it correct to modify the land of the aircraft password?? And your SQL is domain user?
If it is:
Control Panel-> governance tools-> Services,
Select MSSQLServer, properties, Login tab to modify the current username password
Netizens reply: It's done.