Solve SQL Server (MSSQLServer) Service stop due to 3417 (0xd59) service error

Source: Internet
Author: User
Tags mssql server mssqlserver
Hakuci label: sqlserver service, 3417 (0xd59)

Sql2005 system service cannot be started, detailsError Message:
Title: connect to the server
------------------------------
Cannot connect to sharesun \ sql2005.
------------------------------
Additional information:
An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server 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:
The SQL Server (sql2005) Service stops due to a 3417 (0xd59) service error.

An error is reported when the SQL Server Agent is started.

When you start SQL Server Active Directory helper, an error is reported.

 

Method 1:

Go to the SQL installation directory under "installation drive letter: \ Program Files \", and choose "Folder Options"> View the "color-encrypted or compressed NTFS file" option, after the selection, the compressed file name in the folder is blue. Select all compressed files and right-click Properties-> General-> advanced, remove the option "compressing content to save space.

Method 2:

If the "Compressed Content to save space" option is not displayed in method 1, click the Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL folder, which contains the database file, the color is blue, and it is compressed here, so the service cannot be started. Cancel the compression and solve the problem!

Method 3:

A) I did not copy sql2005 to the local device and installed it directly. After installation, the cmd command cannot be transferred to the original installation path (\ 172.17.0.4 \ D $ \ Microsoft \ sql2005 CN \ SQL Server x86 \ servers), and setup.exe cannot be run.

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

C) copy the original SQL server2005 folder to a local directory before installing it.

D) after installing SQL server2005, follow the above steps to drop the master database hung and run cmd on D: \ SQL Server x86 \ servers, you can use the following commands (sapwd can be specified at will, and 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 = MSSQL Server reinstall = SQL _engine rebuilddatabase = 1 sapwd = 123

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

F) then open c: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data and find the Master. MDF and mastlog. LDF already exists. The entire re-installation process takes 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) according to its method, the first single mode to start SQL server2005

B) Run Restore database master from disk = 'C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ backup \ master in cmd. bak ', the whole process may be small because of small data, just 1-2 minutes.

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.