Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server express 2008 express wont start Expand / Collapse
Author
Message
Posted Monday, November 26, 2012 6:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 5:21 AM
Points: 25, Visits: 96
Hi,

this morning sql server 2008 express installed on my dev machine won't work, worked fine yesterday

the service wont start !


and in the config manager i get this :




any help is more than welcome ...

thanks and good day
Post #1388584
Posted Monday, November 26, 2012 6:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 40,438, Visits: 36,895
What does the SQL error log say? The screenshots don't say anything useful (and I can tell that even though I don't speak French )


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1388588
Posted Monday, November 26, 2012 7:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 5:21 AM
Points: 25, Visits: 96
okaya okay
ps : i am a beginer on sql server

here the content of the errorlog file

2012-11-26 14:49:03.61 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

2012-11-26 14:49:03.61 Server (c) 2005 Microsoft Corporation.
2012-11-26 14:49:03.62 Server All rights reserved.
2012-11-26 14:49:03.62 Server Server process ID is 5864.
2012-11-26 14:49:03.62 Server System Manufacturer: 'MSI', System Model: 'MS-7519'.
2012-11-26 14:49:03.62 Server Authentication mode is WINDOWS-ONLY.
2012-11-26 14:49:03.62 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2012-11-26 14:49:03.62 Server This instance of SQL Server last reported using a process ID of 2668 at 26/11/2012 14:37:19 (local) 26/11/2012 13:37:19 (UTC). This is an informational message only; no user action is required.
2012-11-26 14:49:03.62 Server Registry startup parameters:
-d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf
-e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2012-11-26 14:49:03.63 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2012-11-26 14:49:03.63 Server Detected 2 CPUs. This is an informational message; no user action is required.
2012-11-26 14:49:03.65 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2012-11-26 14:49:03.67 Server Node configuration: node 0: CPU mask: 0x0000000000000003 Active CPU mask: 0x0000000000000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2012-11-26 14:49:03.69 spid5s Using 'dbghelp.dll' version '4.0.5'
2012-11-26 14:49:03.69 spid5s ***Stack Dump being sent to c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\LOG\SQLDump0038.txt
2012-11-26 14:49:03.69 spid5s SqlDumpExceptionHandler: Process 5 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2012-11-26 14:49:03.69 spid5s * *******************************************************************************
2012-11-26 14:49:03.69 spid5s *
2012-11-26 14:49:03.69 spid5s * BEGIN STACK DUMP:
2012-11-26 14:49:03.69 spid5s * 11/26/12 14:49:03 spid 5
2012-11-26 14:49:03.69 spid5s *
2012-11-26 14:49:03.69 spid5s *
2012-11-26 14:49:03.69 spid5s * Exception Address = 00000000802BF340 Module(UNKNOWN+0000000000000000)
2012-11-26 14:49:03.69 spid5s * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2012-11-26 14:49:03.69 spid5s * Access Violation occurred writing address 00000000802BF340
2012-11-26 14:49:03.69 spid5s *
2012-11-26 14:49:03.69 spid5s *
2012-11-26 14:49:03.69 spid5s * MODULE BASE END SIZE
2012-11-26 14:49:03.69 spid5s * sqlservr 00000000009F0000 0000000004203FFF 03814000
2012-11-26 14:49:03.69 spid5s * ntdll 00000000779F0000 0000000077B9AFFF 001ab000
2012-11-26 14:49:03.69 spid5s * kernel32 00000000777D0000 00000000778EEFFF 0011f000
2012-11-26 14:49:03.69 spid5s * KERNELBASE 000007FEFDBD0000 000007FEFDC3AFFF 0006b000
2012-11-26 14:49:03.69 spid5s * MSVCR80 000000006D120000 000000006D1E8FFF 000c9000
2012-11-26 14:49:03.69 spid5s * msvcrt 000007FEFE190000 000007FEFE22EFFF 0009f000
2012-11-26 14:49:03.69 spid5s * MSVCP80 00000000557C0000 00000000558C8FFF 00109000
2012-11-26 14:49:03.69 spid5s * ADVAPI32 000007FEFE6F0000 000007FEFE7CAFFF 000db000
2012-11-26 14:49:03.69 spid5s * sechost 000007FEFFCE0000 000007FEFFCFEFFF 0001f000
2012-11-26 14:49:03.69 spid5s * RPCRT4 000007FEFEE20000 000007FEFEF4DFFF 0012e000
2012-11-26 14:49:03.69 spid5s * sqlos 000000006D000000 000000006D006FFF 00007000
2012-11-26 14:49:03.69 spid5s * Secur32 000007FEFD7C0000 000007FEFD7CAFFF 0000b000
2012-11-26 14:49:03.69 spid5s * SSPICLI 000007FEFD7F0000 000007FEFD814FFF 00025000
2012-11-26 14:49:03.69 spid5s * pdh 000007FEF2EA0000 000007FEF2EEDFFF 0004e000
2012-11-26 14:49:03.69 spid5s * SHLWAPI 000007FEFDF00000 000007FEFDF70FFF 00071000
2012-11-26 14:49:03.69 spid5s * GDI32 000007FEFEDB0000 000007FEFEE16FFF 00067000
2012-11-26 14:49:03.69 spid5s * USER32 00000000778F0000 00000000779E9FFF 000fa000
2012-11-26 14:49:03.69 spid5s * LPK 000007FEFE660000 000007FEFE66DFFF 0000e000
2012-11-26 14:49:03.70 spid5s * USP10 000007FEFE590000 000007FEFE659FFF 000ca000
2012-11-26 14:49:03.70 spid5s * USERENV 000007FEFCCA0000 000007FEFCCBDFFF 0001e000
2012-11-26 14:49:03.70 spid5s * profapi 000007FEFD950000 000007FEFD95EFFF 0000f000
2012-11-26 14:49:03.70 spid5s * WINMM 000007FEFA270000 000007FEFA2AAFFF 0003b000
2012-11-26 14:49:03.70 spid5s * opends60 000000006D0B0000 000000006D0B7FFF 00008000
2012-11-26 14:49:03.70 spid5s * NETAPI32 000007FEFBCF0000 000007FEFBD05FFF 00016000
2012-11-26 14:49:03.70 spid5s * netutils 000007FEFBCE0000 000007FEFBCEBFFF 0000c000
2012-11-26 14:49:03.70 spid5s * srvcli 000007FEFD720000 000007FEFD742FFF 00023000
2012-11-26 14:49:03.70 spid5s * wkscli 000007FEFBCC0000 000007FEFBCD4FFF 00015000
2012-11-26 14:49:03.70 spid5s * LOGONCLI 000007FEFCFD0000 000007FEFCFFFFFF 00030000
2012-11-26 14:49:03.70 spid5s * SAMCLI 000007FEFBCA0000 000007FEFBCB3FFF 00014000
2012-11-26 14:49:03.70 spid5s * BatchParser 0000000056BD0000 0000000056BFBFFF 0002c000
2012-11-26 14:49:03.70 spid5s * IMM32 000007FEFEA40000 000007FEFEA6DFFF 0002e000
2012-11-26 14:49:03.70 spid5s * MSCTF 000007FEFE870000 000007FEFE978FFF 00109000
2012-11-26 14:49:03.70 spid5s * psapi 0000000077BC0000 0000000077BC6FFF 00007000
2012-11-26 14:49:03.70 spid5s * instapi10 00000000597E0000 00000000597ECFFF 0000d000
2012-11-26 14:49:03.70 spid5s * cscapi 000007FEF9CB0000 000007FEF9CBEFFF 0000f000
2012-11-26 14:49:03.70 spid5s * sqlevn70 000000004F060000 000000004F2C9FFF 0026a000
2012-11-26 14:49:03.70 spid5s * sqlevn70 0000000005660000 000000000585CFFF 001fd000
2012-11-26 14:49:03.70 spid5s * CRYPTSP 000007FEFD1E0000 000007FEFD1F6FFF 00017000
2012-11-26 14:49:03.70 spid5s * rsaenh 000007FEFCEE0000 000007FEFCF26FFF 00047000
2012-11-26 14:49:03.70 spid5s * CRYPTBASE 000007FEFD880000 000007FEFD88EFFF 0000f000
2012-11-26 14:49:03.70 spid5s * BROWCLI 000007FEF7320000 000007FEF7331FFF 00012000
2012-11-26 14:49:03.70 spid5s * AUTHZ 000007FEFD3D0000 000007FEFD3FEFFF 0002f000
2012-11-26 14:49:03.70 spid5s * MSCOREE 000007FEF6350000 000007FEF63BEFFF 0006f000
2012-11-26 14:49:03.70 spid5s * mscoreei 000007FEF61B0000 000007FEF6248FFF 00099000
2012-11-26 14:49:03.70 spid5s * ole32 000007FEFDF80000 000007FEFE180FFF 00201000
2012-11-26 14:49:03.70 spid5s * credssp 000007FEFCDF0000 000007FEFCDF8FFF 00009000
2012-11-26 14:49:03.70 spid5s * msv1_0 000007FEFD110000 000007FEFD160FFF 00051000
2012-11-26 14:49:03.70 spid5s * cryptdll 000007FEFD4C0000 000007FEFD4D3FFF 00014000
2012-11-26 14:49:03.70 spid5s * kerberos 000007FEFD200000 000007FEFD2B2FFF 000b3000
2012-11-26 14:49:03.70 spid5s * MSASN1 000007FEFD9F0000 000007FEFD9FEFFF 0000f000
2012-11-26 14:49:03.70 spid5s * schannel 000007FEFCF70000 000007FEFCFC8FFF 00059000
2012-11-26 14:49:03.70 spid5s * CRYPT32 000007FEFDA60000 000007FEFDBC5FFF 00166000
2012-11-26 14:49:03.70 spid5s * security 0000000071E40000 0000000071E42FFF 00003000
2012-11-26 14:49:03.70 spid5s * WS2_32 000007FEFE9F0000 000007FEFEA3CFFF 0004d000
2012-11-26 14:49:03.70 spid5s * NSI 000007FEFE580000 000007FEFE587FFF 00008000
2012-11-26 14:49:03.70 spid5s * dbghelp 0000000009110000 000000000926DFFF 0015e000
2012-11-26 14:49:03.70 spid5s *
2012-11-26 14:49:03.70 spid5s * P1Home: 0000000008BAD300: 00000000C0000005 0000000000000000 00000000802BF340 FFFFF6FB00000002 0000000000000008 00000000802BF340
2012-11-26 14:49:03.70 spid5s * P2Home: 0000000008BACE10: 0000000008BAD300 0000000008BACE10 0000000000000000 0000000000000000 FFFFFFFFFFFFFFFE 0000000000B11B8E
2012-11-26 14:49:03.70 spid5s * P3Home: 0000000000000000:
2012-11-26 14:49:03.70 spid5s * P4Home: 0000000000000000:
2012-11-26 14:49:03.70 spid5s * P5Home: FFFFFFFFFFFFFFFE:
2012-11-26 14:49:03.70 spid5s * P6Home: 0000000000B11B8E: 909090C338C48348 9090909090909090 840F01F983419090 7891014800CA8676 0180910148000001 8B48038B48C30000
2012-11-26 14:49:03.70 spid5s * ContextFlags: 000000000010001F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2012-11-26 14:49:03.70 spid5s * MxCsr: 0000000000001F80:
2012-11-26 14:49:03.70 spid5s * SegCs: 0000000000000033:
2012-11-26 14:49:03.70 spid5s * SegDs: 000000000000002B:
2012-11-26 14:49:03.70 spid5s * SegEs: 000000000000002B:
2012-11-26 14:49:03.70 spid5s * SegFs: 0000000000000053:
2012-11-26 14:49:03.70 spid5s * SegGs: 000000000000002B:
2012-11-26 14:49:03.70 spid5s * SegSs: 000000000000002B:
2012-11-26 14:49:03.70 spid5s * EFlags: 0000000000010202: B19000000000001F FFFF0000000077B2 000000000000FFFF 0000000000000000 0FA0000000000000 0000000000000000
2012-11-26 14:49:03.70 spid5s * Rax: 0000000000000001:
2012-11-26 14:49:03.70 spid5s * Rcx: 0000000000000000:
2012-11-26 14:49:03.70 spid5s * Rdx: 0000000000000004:
2012-11-26 14:49:03.70 spid5s * Rbx: 00000000802BF340: 0000000000000000 0000000000000000 0000000000000000 0000000000000049 00000000802BC080 00000000000FFFFF
2012-11-26 14:49:03.70 spid5s * Rsp: 0000000008BAD3D0: 0000000400000000 000007FFFFF9B4A8 00000000802BC080 0000000002385A43 00000000802BF340 000000000000000C
2012-11-26 14:49:03.70 spid5s * Rbp: 0000000008BADF80: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000CBD84AB02FBB
2012-11-26 14:49:03.70 spid5s * Rsi: 000000000000000C:
2012-11-26 14:49:03.70 spid5s * Rdi: 00000000802BC080: 00000000009F4480 0000000000002000 0000000000000061 000000008029E300 0000000100000010 0000000000547B88
2012-11-26 14:49:03.70 spid5s * R8: 0000000080000000: 0000000000000000 0000000080000080 0000000100000002 0000000000000001 0000000000060003 00000000000019D0
2012-11-26 14:49:03.70 spid5s * R9: 0000000001B23100: 909090C3022B018B 9090909090909090 4808588948C48B48 4818708948106889 EC83485441207889 4CEA8B48C0854520
2012-11-26 14:49:03.70 spid5s * R10: 00000000009F4480: 0000000001A91630 00000000009FF7D0 00000000009FF770 0000000002825A40 0000000001A95FD0 00000000009F58F0
2012-11-26 14:49:03.70 spid5s * R11: 0000000008BAD300: 00000000C0000005 0000000000000000 00000000802BF340 FFFFF6FB00000002 0000000000000008 00000000802BF340
2012-11-26 14:49:03.70 spid5s * R12: 0000000000400002:
2012-11-26 14:49:03.70 spid5s * R13: 0000000000000008:
2012-11-26 14:49:03.70 spid5s * R14: 0000000000000001:
2012-11-26 14:49:03.70 spid5s * R15: 0000000000000000:
2012-11-26 14:49:03.70 spid5s * Rip: 00000000802BF340: 0000000000000000 0000000000000000 0000000000000000 0000000000000049 00000000802BC080 00000000000FFFFF
2012-11-26 14:49:03.70 spid5s * *******************************************************************************
2012-11-26 14:49:03.70 spid5s * -------------------------------------------------------------------------------
2012-11-26 14:49:03.70 spid5s * Short Stack Dump
2012-11-26 14:49:03.70 spid5s 00000000802BF340 Module(UNKNOWN+0000000000000000)
2012-11-26 14:49:03.70 spid5s 0000000400000000 Module(UNKNOWN+0000000000000000)
2012-11-26 14:49:03.70 spid5s 000007FFFFF9B4A8 Module(UNKNOWN+0000000000000000)
2012-11-26 14:49:03.70 spid5s 00000000802BC080 Module(UNKNOWN+0000000000000000)
2012-11-26 14:49:03.70 spid5s 0000000002385A43 Module(sqlservr+0000000001995A43)
2012-11-26 14:49:03.71 spid5s 00000000026E147D Module(sqlservr+0000000001CF147D)
2012-11-26 14:49:03.71 spid5s 00000000026F8809 Module(sqlservr+0000000001D08809)
2012-11-26 14:49:03.71 spid5s 00000000032270D6 Module(sqlservr+00000000028370D6)
2012-11-26 14:49:03.71 spid5s 0000000003227ED3 Module(sqlservr+0000000002837ED3)
2012-11-26 14:49:03.71 spid5s 0000000000A0163B Module(sqlservr+000000000001163B)
2012-11-26 14:49:03.71 spid5s 0000000000A012FA Module(sqlservr+00000000000112FA)
2012-11-26 14:49:03.71 spid5s 0000000000A00E35 Module(sqlservr+0000000000010E35)
2012-11-26 14:49:03.71 spid5s 0000000000F80E50 Module(sqlservr+0000000000590E50)
2012-11-26 14:49:03.71 spid5s 0000000000F809A0 Module(sqlservr+00000000005909A0)
2012-11-26 14:49:03.71 spid5s 0000000000F99AB0 Module(sqlservr+00000000005A9AB0)
2012-11-26 14:49:03.71 spid5s 0000000000F8013F Module(sqlservr+000000000059013F)
2012-11-26 14:49:03.71 spid5s 000000006D1237D7 Module(MSVCR80+00000000000037D7)
2012-11-26 14:49:03.72 spid5s 000000006D123894 Module(MSVCR80+0000000000003894)
2012-11-26 14:49:03.72 spid5s 00000000777EF56D Module(kernel32+000000000001F56D)
2012-11-26 14:49:03.72 spid5s 0000000077A23281 Module(ntdll+0000000000033281)
2012-11-26 14:49:03.72 spid5s Stack Signature for the dump is 0x00000001802E7724
2012-11-26 14:49:03.96 spid5s External dump process return code 0x20000001.
External dump process returned no errors.

2012-11-26 14:49:03.96 spid5s Error: 17311, Severity: 16, State: 1.
2012-11-26 14:49:03.96 spid5s SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).


i hope that is the right log file :)
Post #1388598
Posted Monday, November 26, 2012 7:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 40,438, Visits: 36,895
Try rebooting the machine, see if SQL will start then.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1388603
Posted Monday, November 26, 2012 7:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 5:21 AM
Points: 25, Visits: 96
already tried, but i will try one more time

i will be back !
Post #1388605
Posted Monday, November 26, 2012 7:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:43 AM
Points: 6,641, Visits: 14,226
as a side note, have you changed any CPU settings in the BIOS, the reason i ask is because the stack dump occurs right after CPU detection

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1388616
Posted Monday, November 26, 2012 7:25 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 40,438, Visits: 36,895
Have you installed anything new, any patches, drivers, etc?

Maybe a reinstall of SQL?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1388623
Posted Monday, November 26, 2012 7:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 5:21 AM
Points: 25, Visits: 96
Fixed !

after a "second" reboot the server start without problem .....
didn't understand why


thanks you very very match
Post #1388639
Posted Monday, November 26, 2012 8:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:43 AM
Points: 6,641, Visits: 14,226
Spooky huh!


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1388647
Posted Monday, November 26, 2012 8:22 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 40,438, Visits: 36,895
Weird.

When you have some time, see if you can dig up a memory test tool, make sure your memory's working properly.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1388652
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse