Answered by:
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 3, 2013 3:21 PM
Answers
-
Ok. You might try to repair your SQL Server installation, or contact Microsoft support.
David
David http://blogs.msdn.com/b/dbrowne/
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 3, 2013 8:42 PM
- Marked as answer by Fanny Liu Friday, September 13, 2013 1:41 AM
Tuesday, September 3, 2013 7:49 PM
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 3, 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.txtTuesday, September 3, 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 3, 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 3, 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/
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 3, 2013 8:42 PM
- Marked as answer by Fanny Liu Friday, September 13, 2013 1:41 AM
Tuesday, September 3, 2013 7:49 PM