none
Cannot Start Sql Server 2005 service.

    Question

  • When i try to start the Sql Server (MSSQLSERVER) service, get the following error :

     

    Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.

     

    In the eventvwr, this is the error :

    The SQL Server (MSSQLSERVER) service terminated with service-specific error 3417 (0xD59).

     

    Any help please !!

    Monday, July 21, 2008 5:02 PM

Answers

All replies

  • Thanks Shelly. I thought this would help me but NO LUCK  

    For your information : My OS is Windows Server 2003

     

    Tuesday, July 22, 2008 7:24 AM
  • Can you please check and post the contents of the Sql Server errror log ?..

    - Deepak
    Tuesday, July 22, 2008 7:29 AM
    Moderator
  • Yup. Here it is.

    Looks like, the compression issue, but for the Data folder compress attributes are already unchecked !!!

     

    2008-07-22 12:40:00.32 Server      Database mirroring has been enabled on this instance of SQL Server.
    2008-07-22 12:40:00.32 spid4s      Starting up database 'master'.
    2008-07-22 12:40:00.32 spid4s      Error: 5118, Severity: 16, State: 1.
    2008-07-22 12:40:00.32 spid4s      The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    2008-07-22 12:40:00.32 spid4s      Error: 5118, Severity: 16, State: 1.
    2008-07-22 12:40:00.32 spid4s      The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    2008-07-22 12:40:00.32 spid4s      Error: 5118, Severity: 16, State: 1.
    2008-07-22 12:40:00.32 spid4s      The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    2008-07-22 12:40:00.32 spid4s      Error: 5118, Severity: 16, State: 1.
    2008-07-22 12:40:00.32 spid4s      The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

    • Proposed as answer by M2211 Monday, March 25, 2013 2:58 PM
    Tuesday, July 22, 2008 7:53 AM
  • Well Thanks All ! I get it resolved -

     

    Tried all the three solutions mentioned here http://www.tomrafteryit.net/sql-server-2005-express-error-3417/

    and Simply Restarted the system. But not sure which one worked

    Tuesday, July 22, 2008 8:00 AM
  • Guys,

    I am having a similar problem. I cannot get our company's test sql server up and running. The OS is Windows Server 2003 Standard x64 Edition Service Pack 2.We have Sql Server 2005 Installed on the server. The problem is that the MSSQLSERVER service does not start and gives error code 3417. I already tried running the setup.exe from the previous install directory using the following command:

    start /wait C:\SQLServerDVD\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<newstrongpassword>

    The command ran without any errors and I thought that will rebuild the master database and we will be able to start the service but that was not the case. I was still unable to start the service. Looking at the Windows Event Logs, I see following:


    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 17207
    Date: 12/9/2008
    Time: 5:18:28 PM
    User: N/A
    Computer: <COMPUTER_NAME>
    Description:
    FCB::RemoveAlternateStreams: Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 37 43 00 00 10 00 00 00 7C......
    0008: 0a 00 00 00 49 00 43 00 ....I.C.
    0010: 55 00 42 00 45 00 42 00 U.B.E.B.
    0018: 45 00 54 00 41 00 00 00 E.T.A...
    0020: 00 00 00 00 ....

    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 9003
    Date: 12/9/2008
    Time: 5:18:28 PM
    User: N/A
    Computer: <COMPUTER_NAME>
    Description:
    The log scan number (891:104:2) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 2b 23 00 00 14 00 00 00 +#......
    0008: 0a 00 00 00 49 00 43 00 ....I.C.
    0010: 55 00 42 00 45 00 42 00 U.B.E.B.
    0018: 45 00 54 00 41 00 00 00 E.T.A...
    0020: 00 00 00 00 ....

    I have checked for compression of log and data file for master database and they are not compressed. I have looked at a lot of forums and non of the resolutions or problem symptoms seems to be matching mine. Any help would be greatly appreciated.

    Thanks!
    Wednesday, December 10, 2008 2:23 PM
  • Take a look at this:

    http://www.tomrafteryit.net/sql-server-2005-express-error-3417/

    I am a software vendor and our application uses SQL Server Express 2005 as a backend.  I have a user who is getting the same error message as the OP when he tries to start the SQL Server service.

    I'd like to try the suggestions in the site above, but the link is broken.  Does someone know if the site has moved or recalls what the three solutions were on the original blog  post?

    Wednesday, January 12, 2011 7:26 PM
  • BMRH,

     

    "I'd like to try the suggestions in the site above, but the link is broken.  Does someone know if the site has moved or recalls what the three solutions were on the original blog  post?"

     

     

    My bad - that site is mine but due to persistent hacking of the server and blog db I had to move it to a hosted blog provider.

     

    You can find that post now at http://tomraftery.com/2004/09/13/sql-server-2005-express-error-3417/

     

    Hope that helps,

     

    Warm regards,

     

    Tom

    Wednesday, January 12, 2011 8:56 PM
  • Ok, I found the email address of the owner of the above blog post.  He has moved his blog and below is a link to the its new location:

    http://tomraftery.com/2004/09/13/sql-server-2005-express-error-3417/

    Wednesday, January 12, 2011 8:56 PM
  • When attempting to go to that new blog site, it is blocked since it has been blocked as a malicious URL. Has this one been hacked too?
    Monday, November 14, 2011 9:07 PM