Can not start MSSQLSERVER !!!

Posted on 2006-05-17
Last Modified: 2012-05-05

I can not start the sql server 2000 on my local machine. I tried "SQL Server Service Manager" and services in Administrative Tools.

When trying to run MSSQLSERVER from Services I got the following error message:

"The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

The following is a copy of Applications Event Viewer

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17055
Date:            17/05/2006
Time:            12:00:58 م
User:            N/A
Computer:      BELAL
18052 :
Error: 2775, Severity: 16, State: 1.

For more information, see Help and Support Center at
0000: 84 46 00 00 10 00 00 00   „F......
0008: 06 00 00 00 42 00 45 00   ....B.E.
0010: 4c 00 41 00 4c 00 00 00   L.A.L...
0018: 07 00 00 00 6d 00 61 00   ....m.a.
0020: 73 00 74 00 65 00 72 00   s.t.e.r.
0028: 00 00                     ..      
Question by:bmarzouk
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    check out the ERRORLOG file in the log folder of the sql server installation, it will show in more details what happens.

    you might post the relevant part here if you don't know how to interprete the messages

    Author Comment

    I can not understand this log. But it is available at the followung URL for download
    LVL 142

    Accepted Solution

    This looks like the master database files are either corrupt or some other problem, as indicated in the dump files.
    I think the best is to contact Microsoft to open a case (I assume you have a maintenance contract/licenses paid)...
    I doubt any of the experts (unless he is M$ employee with SQL debug tools) can do anything...

    Author Comment

    How can I get the current installed service pack on the SQL Server 2000?

    I want also to know which type is it? (Standard, Personal, Enterprise, ... ).

    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    it is noted in the ERRORLOG file, the 8.00.760 indicate that it is SP3, and it clearly indicates PERSONAL Edition

    2006-05-17 12:58:56.39 server    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
          Dec 17 2002 14:22:05
          Copyright (c) 1988-2003 Microsoft Corporation
          Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    Author Comment

    Is there a query or stored procedure to get this information?

    By the way, what are possible causes for master db to be corrupted? How can I prevent this to happen in the future?
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    >Is there a query or stored procedure to get this information?
    if you cannot start the db, this is not possible.

    if the server is up, you can run
    select @@version

    >By the way, what are possible causes for master db to be corrupted? How can I prevent this to happen in the future?
    My guess is that it is the master db which is corrupt, not sure though.
    master db corrupt could be due to bad disk for example...

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now