none
Windows could nto start the SQL Server service on the local computer - Error 1067: The process terminated unexpectedly

    Question

  • The server restarted and SQL services will not start, steps and actions taken.

    1 - verified user credentials, created new user (with priveleges)

    2 - verified disk space

    The log file is below:

    Version=1
    EventType=APPCRASH
    EventTime=130226933008312749
    ReportType=2
    Consent=1
    ReportIdentifier=dfb8856e-14a7-11e3-87fb-e61f13c03697
    IntegratorReportIdentifier=dfb8856d-14a7-11e3-87fb-e61f13c03697
    Response.type=4
    Sig[0].Name=Application Name
    Sig[0].Value=sqlservr.exe
    Sig[1].Name=Application Version
    Sig[1].Value=2009.100.1600.1
    Sig[2].Name=Application Timestamp
    Sig[2].Value=4bb6b40b
    Sig[3].Name=Fault Module Name
    Sig[3].Value=sqlservr.exe
    Sig[4].Name=Fault Module Version
    Sig[4].Value=2009.100.1600.1
    Sig[5].Name=Fault Module Timestamp
    Sig[5].Value=4bb6b40b
    Sig[6].Name=Exception Code
    Sig[6].Value=c0000005
    Sig[7].Name=Exception Offset
    Sig[7].Value=00000000000a1c61
    DynamicSig[1].Name=OS Version
    DynamicSig[1].Value=6.1.7600.2.0.0.16.7
    DynamicSig[2].Name=Locale ID
    DynamicSig[2].Value=1033
    DynamicSig[22].Name=Additional Information 1
    DynamicSig[22].Value=518c
    DynamicSig[23].Name=Additional Information 2
    DynamicSig[23].Value=518cbb03bfcafbf47bc93324af1a1165
    DynamicSig[24].Name=Additional Information 3
    DynamicSig[24].Value=5dc7
    DynamicSig[25].Name=Additional Information 4
    DynamicSig[25].Value=5dc72c14e535d649ef1c45ebf5324ecc
    UI[2]=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
    UI[3]=SQL Server Windows NT - 64 Bit has stopped working
    UI[4]=Windows can check online for a solution to the problem.
    UI[5]=Check online for a solution (recommended)
    UI[6]=Check for a solution later (recommended)
    UI[7]=Close
    UI[8]=SQL Server Windows NT - 64 Bit stopped working and was closed
    UI[9]=A problem caused the application to stop working correctly. Windows will notify you if a solution is available.
    UI[10]=&Close
    LoadedModule[0]=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
    LoadedModule[1]=C:\Windows\SYSTEM32\ntdll.dll
    LoadedModule[2]=C:\Windows\system32\kernel32.dll
    LoadedModule[3]=C:\Windows\system32\KERNELBASE.dll
    LoadedModule[4]=C:\Windows\system32\ADVAPI32.dll
    LoadedModule[5]=C:\Windows\system32\msvcrt.dll
    LoadedModule[6]=C:\Windows\SYSTEM32\sechost.dll
    LoadedModule[7]=C:\Windows\system32\RPCRT4.dll
    LoadedModule[8]=C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_88dce9872fb18caf\MSVCR80.dll
    LoadedModule[9]=C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_88dce9872fb18caf\MSVCP80.dll
    LoadedModule[10]=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlos.dll
    LoadedModule[11]=C:\Windows\system32\Secur32.dll
    LoadedModule[12]=C:\Windows\system32\SSPICLI.DLL
    LoadedModule[13]=C:\Windows\system32\pdh.dll
    LoadedModule[14]=C:\Windows\system32\SHLWAPI.dll
    LoadedModule[15]=C:\Windows\system32\GDI32.dll
    LoadedModule[16]=C:\Windows\system32\USER32.dll
    LoadedModule[17]=C:\Windows\system32\LPK.dll
    LoadedModule[18]=C:\Windows\system32\USP10.dll
    LoadedModule[19]=C:\Windows\system32\USERENV.dll
    LoadedModule[20]=C:\Windows\system32\profapi.dll
    LoadedModule[21]=C:\Windows\system32\WINMM.dll
    LoadedModule[22]=C:\Windows\system32\IPHLPAPI.DLL
    LoadedModule[23]=C:\Windows\system32\NSI.dll
    LoadedModule[24]=C:\Windows\system32\WINNSI.DLL
    LoadedModule[25]=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\opends60.dll
    LoadedModule[26]=C:\Windows\system32\NETAPI32.dll
    LoadedModule[27]=C:\Windows\system32\netutils.dll
    LoadedModule[28]=C:\Windows\system32\srvcli.dll
    LoadedModule[29]=C:\Windows\system32\wkscli.dll
    LoadedModule[30]=C:\Windows\system32\LOGONCLI.DLL
    LoadedModule[31]=C:\Windows\system32\SAMCLI.DLL
    LoadedModule[32]=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\BatchParser.dll
    LoadedModule[33]=C:\Windows\system32\IMM32.DLL
    LoadedModule[34]=C:\Windows\system32\MSCTF.dll
    LoadedModule[35]=C:\Windows\system32\psapi.dll
    LoadedModule[36]=C:\Program Files\Microsoft SQL Server\100\Shared\instapi10.dll
    LoadedModule[37]=C:\Windows\system32\cscapi.dll
    FriendlyEventName=Stopped working
    ConsentKey=APPCRASH
    AppName=SQL Server Windows NT - 64 Bit
    AppPath=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe

    Tuesday, September 03, 2013 3:21 PM

Answers

All replies

  • What's in the SQL Log at

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\log\ERRORLOG

    ?

    David


    David http://blogs.msdn.com/b/dbrowne/

    Tuesday, September 03, 2013 3:23 PM
  • The Log is too long.  It does nto seem to correspond with the error i am having.  I had one log at 3 am this morning when the backup ran, however, it looks like it is in reguards to the backup that ran last night.  i have no other SQL error log in the prior months.

    SQL Server WIndows NT - 64 Bit has stopped working

       Fault Module Version: 8.0.50727.4927
      Fault Module Timestamp: 4a27427d
      Exception Code: c0000005
      Exception Offset: 000000000003a8b5
      OS Version: 6.1.7600.2.0.0.16.7
      Locale ID: 1033
      Additional Information 1: 0f35
      Additional Information 2: 0f357b8c23fdb17c9356f5ecbf4026ae
      Additional Information 3: 4da6
      Additional Information 4: 4da692d5249743186388a298dab7d8cd

    Read our privacy statement online:
      http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

    If the online privacy statement is not available, please read our privacy statement offline:
      C:\Windows\system32\en-US\erofflps.txt
    Tuesday, September 03, 2013 3:57 PM
  • When you try to start SQL Server it should produce a new ERRORLOG, and if it fails to start the ERRORLOG should be short and possibly informative.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Tuesday, September 03, 2013 4:04 PM
  • I understand what you are saying to do.

    I am not getting a new error log, even when i try to start the service.  I just cleared all the logs out, and it is not generating a new one when i attempt to start the sql service.  

    Tuesday, September 03, 2013 6:15 PM
  • Ok.  You might try to repair your SQL Server installation, or contact Microsoft support.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Tuesday, September 03, 2013 7:49 PM