The SQL Server (MSSQLServer) Service stops due to a 3417 (0xd59) service error.

SQL 2005 system service cannot be started. error message :
title: connect to the server
--------------------------
cannot connect to sharesun/ SQL 2005.
------------------------------
additional information:
An error occurred while establishing a connection with the server. When connected to SQL Server 2005, by default, SQL server does not allow remote connection, which may cause this failure. (Provider: SQL network interface, error: 26-An error occurred while locating the specified server/instance. (Microsoft SQL server, error: -1)

After checking the system log, the following prompt is displayed:
Event Type: Error
Event Source: Service Control Manager
Event Type: None
Event ID: 7024
Date: 2010-6-22
Event: 19:47:08
User: N/
COMPUTER: sharesun
Description:
SQLServer (SQL2005) Service3417(0xd59) stops due to a service error.

StartSQLServer Agent reports an error

StartSQLServer Active Directory helper reports an error

 

Method 1:

To the installation drive letter:/program files/SQLInstallation directory, Folder Options-> View with the "color explicitly encrypted or compressed NTFS files" option, after selection, the compressed file name in the folder is blue, select all files to be compressed, right-click Properties, and choose General> advanced to remove the option "compressing content to save space.

Method 2:

If the option "compressing content to save space" is not displayed in method 1, click program files/MicrosoftSQLThe server/mssql.1/MSSQL folder contains database files and the color is blue. The folder is compressed, so the service cannot be started. Cancel the compression and solve the problem!

 

 

Method 3:

A) I didn'tSQL2005 copy to the local device and install it directly. After installation, the CMD command cannot be transferred to the original installation path (// 172.17.0.4/d $/Microsoft/SQL2005 cN/SQLServer x86/servers), and you cannot run setup.exe.

B) An error is reported under any non-original installation path:

C)SQLThe original folder of server2005 is copied to a local directory before installation.

D) install it nowSQLServer2005, and then drop the master database Hung, CMD runs on D :/SQLServer x86/servers, which can be specified by the following command (sapwd can be specified at will, it is the SA password to be entered later, in the middle, I only used the first photo below several times, so I didn't need the second one. I don't know why)

Start/Wait setup.exe/QB InstanceName = MSSQLServer reinstall =SQL_ Engine rebuilddatabase = 1 sapwd = 123

Setup.exe/QB InstanceName = MSSQLServer reinstall =SQL_ Engine rebuilddatabase = 1 sapwd = 123

E) the system will automatically remind you to reinstall it.

F) then open C:/program files/MicrosoftSQLServer/mssql.1/MSSQL/data, it is found that both master. MDF and mastlog. LDF already exist, the whole re-installation process is about 4-5 minutes.

3. PreviousArticleWhen it comes to restoring the master database, it may be because the master database has some settings that need to be changed after installation, and then it is backed up.

A) start in a single mode according to its method.SQLServer2005

B) Run Restore database master from disk = 'C:/program files/MicrosoftSQLServer/mssql.1/MSSQL/backup/master. Bak ', the whole process may be completed in 1-2 minutes because of small data.