sql server 2012 express error 0x851A0019 Could not find the Database Engine startup handle. (2023)

>

All replies

• 

  Sign in to vote

  SQL_ERRORLOG file

  2013-03-28 11:46:27.25 Server Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
  Feb 10 2012 19:39:15
  Copyright (c) Microsoft Corporation
  Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

  2013-03-28 11:46:27.25 Server (c) Microsoft Corporation.
  2013-03-28 11:46:27.29 Server All rights reserved.
  2013-03-28 11:46:27.29 Server Server process ID is 3980.
  2013-03-28 11:46:27.29 Server System Manufacturer: 'Hewlett-Packard', System Model: 'HP Pavilion dv4 Notebook PC'.
  2013-03-28 11:46:27.29 Server Authentication mode is WINDOWS-ONLY.
  2013-03-28 11:46:27.29 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
  2013-03-28 11:46:27.29 Server The service account is 'WORKGROUP\MICHAEL-PC$'. This is an informational message; no user action is required.
  2013-03-28 11:46:27.29 Server Registry startup parameters:
  -d C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf
  -e C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG
  -l C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
  2013-03-28 11:46:27.29 Server Command Line Startup Parameters:
  -s "MSSQLSERVER"
  -m "SqlSetup"
  -Q
  -q "SQL_Latin1_General_CP1_CI_AS"
  -T 4022
  -T 4010
  -T 3659
  -T 3610
  -T 8015
  -d "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Template Data\master.mdf"
  -l "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Template Data\mastlog.ldf"
  2013-03-28 11:46:27.67 Server SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
  2013-03-28 11:46:27.67 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
  2013-03-28 11:46:27.67 Server Detected 3998 MB of RAM. This is an informational message; no user action is required.
  2013-03-28 11:46:27.67 Server Using conventional memory in the memory manager.
  2013-03-28 11:46:27.74 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
  2013-03-28 11:46:27.79 Server Error: 17750, Severity: 16, State: 6.
  2013-03-28 11:46:27.79 Server Could not load the DLL security.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
  2013-03-28 11:46:27.79 Server Error: 17311, Severity: 16, State: 1.
  2013-03-28 11:46:27.79 Server 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).
  2013-03-28 11:46:27.79 Server Using 'dbghelp.dll' version '4.0.5'
  2013-03-28 11:46:27.81 Server **Dump thread - spid = 0, EC = 0x0000000000000000
  2013-03-28 11:46:27.81 Server ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0011.txt
  2013-03-28 11:46:27.81 Server * *******************************************************************************
  2013-03-28 11:46:27.81 Server *
  2013-03-28 11:46:27.81 Server * BEGIN STACK DUMP:
  2013-03-28 11:46:27.81 Server * 03/28/13 11:46:27 spid 1512
  2013-03-28 11:46:27.81 Server *
  2013-03-28 11:46:27.81 Server * ex_handle_except encountered exception C0000005 - Server terminating
  2013-03-28 11:46:27.81 Server *
  2013-03-28 11:46:27.81 Server *
  2013-03-28 11:46:27.81 Server * MODULE BASE END SIZE
  2013-03-28 11:46:27.81 Server * sqlservr 00000000FF040000
  2013-03-28 11:46:27.81 Server * ntdll 00000000779E0000
  2013-03-28 11:46:27.81 Server * kernel32 0000000077460000
  2013-03-28 11:46:27.81 Server * KERNELBASE 000007FEFDF90000
  2013-03-28 11:46:27.81 Server * ADVAPI32 000007FEFE6A0000
  2013-03-28 11:46:27.81 Server * msvcrt 000007FEFFB50000
  2013-03-28 11:46:27.81 Server * sechost 000007FEFF6B0000
  2013-03-28 11:46:27.81 Server * RPCRT4 000007FEFF530000
  2013-03-28 11:46:27.81 Server * MSVCR100 000000006CC50000
  2013-03-28 11:46:27.81 Server * MSVCP100 000000006CBB0000
  2013-03-28 11:46:27.81 Server * sqlos 000000006EB40000
  2013-03-28 11:46:27.81 Server * NETAPI32 000007FEFBDD0000
  2013-03-28 11:46:27.81 Server * netutils 000007FEFBDC0000
  2013-03-28 11:46:27.81 Server * srvcli 000007FEFDA30000
  2013-03-28 11:46:27.81 Server * wkscli 000007FEFBDA0000
  2013-03-28 11:46:27.81 Server * pdh 000007FEF1880000
  2013-03-28 11:46:27.81 Server * opends60 000000006EB00000
  2013-03-28 11:46:27.81 Server * sqlmin 000007FEE6460000
  2013-03-28 11:46:27.81 Server * USER32 00000000778E0000
  2013-03-28 11:46:27.81 Server * GDI32 000007FEFF7B0000
  2013-03-28 11:46:27.81 Server * LPK 000007FEFFB40000
  2013-03-28 11:46:27.81 Server * USP10 000007FEFFC20000
  2013-03-28 11:46:27.81 Server * ole32 000007FEFE3F0000
  2013-03-28 11:46:27.81 Server * OLEAUT32 000007FEFF6D0000
  2013-03-28 11:46:27.81 Server * Secur32 000007FEFDAD0000
  2013-03-28 11:46:27.81 Server * SSPICLI 000007FEFDCA0000
  2013-03-28 11:46:27.81 Server * PSAPI 0000000077BB0000
  2013-03-28 11:46:27.81 Server * WS2_32 000007FEFF660000
  2013-03-28 11:46:27.81 Server * NSI 000007FEFF920000
  2013-03-28 11:46:27.81 Server * sqlTsEs 000007FEE9220000
  2013-03-28 11:46:27.81 Server * sqldk 000007FEE9ED0000
  2013-03-28 11:46:27.81 Server * WINMM 000007FEFBB60000
  2013-03-28 11:46:27.81 Server * sqllang 000007FEE43E0000
  2013-03-28 11:46:27.81 Server * USERENV 000007FEFD190000
  2013-03-28 11:46:27.81 Server * profapi 000007FEFDE40000
  2013-03-28 11:46:27.81 Server * LOGONCLI 000007FEFD4C0000
  2013-03-28 11:46:27.81 Server * SAMCLI 000007FEFBD80000
  2013-03-28 11:46:27.81 Server * AUTHZ 000007FEFD8A0000
  2013-03-28 11:46:27.81 Server * WINTRUST 000007FEFDF30000
  2013-03-28 11:46:27.81 Server * CRYPT32 000007FEFE000000
  2013-03-28 11:46:27.81 Server * MSASN1 000007FEFDEE0000
  2013-03-28 11:46:27.81 Server * IMM32 000007FEFFBF0000
  2013-03-28 11:46:27.81 Server * MSCTF 000007FEFF9D0000
  2013-03-28 11:46:27.81 Server * CRYPTBASE 000007FEFDCD0000
  2013-03-28 11:46:27.81 Server * instapi110 000007FEF64E0000
  2013-03-28 11:46:27.81 Server * cscapi 000007FEF9EF0000
  2013-03-28 11:46:27.81 Server * sqlevn70 0000000065C40000
  2013-03-28 11:46:27.81 Server * CRYPTSP 000007FEFD6D0000
  2013-03-28 11:46:27.81 Server * rsaenh 000007FEFD3D0000
  2013-03-28 11:46:27.81 Server * imagehlp 000007FEFE780000
  2013-03-28 11:46:27.81 Server * ncrypt 000007FEFD850000
  2013-03-28 11:46:27.81 Server * bcrypt 000007FEFD820000
  2013-03-28 11:46:27.81 Server * bcryptprimitives 000007FEFD310000
  2013-03-28 11:46:27.81 Server * GPAPI 000007FEFD170000
  2013-03-28 11:46:27.81 Server * cryptnet 000007FEF90A0000
  2013-03-28 11:46:27.81 Server * WLDAP32 000007FEFFAE0000
  2013-03-28 11:46:27.81 Server * SHLWAPI 000007FEFF8A0000
  2013-03-28 11:46:27.81 Server * VERSION 000007FEFCFA0000
  2013-03-28 11:46:27.81 Server * credssp 000007FEFD2A0000
  2013-03-28 11:46:27.81 Server * msv1_0 000007FEFD600000
  2013-03-28 11:46:27.81 Server * cryptdll 000007FEFD950000
  2013-03-28 11:46:27.81 Server * kerberos 000007FEFD6F0000
  2013-03-28 11:46:27.81 Server * schannel 000007FEFD460000
  2013-03-28 11:46:27.81 Server * MSCOREE 000007FEF9590000
  2013-03-28 11:46:27.81 Server * mscoreei 000007FEF94F0000
  2013-03-28 11:46:27.81 Server * CLUSAPI 000007FEF7AF0000
  2013-03-28 11:46:27.81 Server * RESUTILS 000007FEF7AD0000
  2013-03-28 11:46:27.81 Server * dbghelp 000000006C010000
  2013-03-28 11:46:27.81 Server *
  2013-03-28 11:46:27.81 Server * P1Home: 0000000000000000:
  2013-03-28 11:46:27.81 Server * P2Home: 0000000000000000:
  2013-03-28 11:46:27.81 Server * P3Home: 0000000001B7A9C0: 000007FEFDF99E70 000007FEFDF90000 000007FEFDFF2F54 000007FEE43E0000 000007FEE6372C8C 00000000FFFFFFFF
  2013-03-28 11:46:27.81 Server * P4Home: 000007FEE44160B8: 004B2122880FC085 17870FC73B489848 1F96F5840F004B21 C38B30247C8B4800 90C35B5E38C48348 2414894C10EC8348
  2013-03-28 11:46:27.81 Server * P5Home: 0000000000000000:
  2013-03-28 11:46:27.81 Server * P6Home: 0000000001B7AB60: 0044004C00510053 0000000077A35D84 0000003100310030 00000000000D8C64 00000000000DA6D0 00000000767A9A5A
  2013-03-28 11:46:27.81 Server * ContextFlags: 000000000010000F: 0000000000000000 00004B070F7CF000 000000000FFFF090 0000000010005000 000000000D3C6000 0000000000000500
  2013-03-28 11:46:27.81 Server * MxCsr: 0000000000001FA0:
  2013-03-28 11:46:27.81 Server * SegCs: 0000000000000033:
  2013-03-28 11:46:27.81 Server * SegDs: 000000000000002B:
  2013-03-28 11:46:27.81 Server * SegEs: 000000000000002B:
  2013-03-28 11:46:27.81 Server * SegFs: 0000000000000053:
  2013-03-28 11:46:27.81 Server * SegGs: 000000000000002B:
  2013-03-28 11:46:27.81 Server * SegSs: 000000000000002B:
  2013-03-28 11:46:27.81 Server * EFlags: 0000000000000206:
  2013-03-28 11:46:27.81 Server * Rax: 00000000767A9A5A:
  2013-03-28 11:46:27.81 Server * Rcx: 0000000001B7AB10: 0000000000000000 0000000000000000 0000000001B7A9C0 000007FEE44160B8 0000000000000000 0000000001B7AB60
  2013-03-28 11:46:27.81 Server * Rdx: 0000000000000000:
  2013-03-28 11:46:27.81 Server * Rbx: 0000000000000000:
  2013-03-28 11:46:27.81 Server * Rsp: 0000000001B7B120: 0000000000000000 0000000000000000 0000000001B7B3A0 0000000000000002 00000000000042AC 0000000000000000
  2013-03-28 11:46:27.81 Server * Rbp: 0000000001B7CCF0: 0068005F00780065 006C0064006E0061 00780065005F0065 0074007000650063 0063006E00650020 0074006E0075006F
  2013-03-28 11:46:27.81 Server * Rsi: 0000000000000000:
  2013-03-28 11:46:27.81 Server * Rdi: 0000000001B7B3A0: 00000000039B7D80 0000000000000000 0000040900000001 FFFFFFFF00000001 0000000000000000 0000000000000001
  2013-03-28 11:46:27.81 Server * R8: 0000000000000000:
  2013-03-28 11:46:27.81 Server * R9: 0000000000000000:
  2013-03-28 11:46:27.81 Server * R10: 0000000000000000:
  2013-03-28 11:46:27.81 Server * R11: 0000000001B7BE20: 0000000000000000 0000000000000000 0000000001B7A9C0 000007FEE44160B8 0000000000000000 0000000001B7AB60
  2013-03-28 11:46:27.81 Server * R12: 0000000000000001:
  2013-03-28 11:46:27.81 Server * R13: 0000000000000001:
  2013-03-28 11:46:27.81 Server * R14: 0000000000000000:
  2013-03-28 11:46:27.81 Server * R15: 000000000000003F:
  2013-03-28 11:46:27.81 Server * Rip: 000007FEFDF99E5D: C3000000C8C48148 9090909090909090 08245C8948909090 D98B4820EC834857 00002AE8FA8B098B 2301840FC0854800
  2013-03-28 11:46:27.81 Server * *******************************************************************************
  2013-03-28 11:46:27.81 Server * -------------------------------------------------------------------------------
  2013-03-28 11:46:27.81 Server * Short Stack Dump
  2013-03-28 11:46:27.82 Server 000007FEFDF99E5D Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.82 Server 000007FEE557F34E Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.82 Server 000007FEE5584233 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.83 Server 000007FEE5583A3A Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.84 Server 000007FEE9F943F5 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.85 Server 00000000774F9460 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.85 Server 0000000077A743B8 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.85 Server 00000000779F85A8 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 0000000077A09D0D Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 00000000779F91AF Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 0000000077A31278 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE4B73A41 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE4B7494D Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE4B67AE3 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE4B62B83 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE515E840 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE5155E40 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 000007FEE5A2AC80 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.86 Server 00000000FF04A8DA Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.87 Server 00000000FF04BA1E Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.87 Server 00000000FF043C28 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.87 Server 000007FEFF6BA82D Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.87 Server 000000007747652D Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.87 Server 0000000077A0C521 Module(UNKNOWN+0000000000000000)
  2013-03-28 11:46:27.87 Server Stack Signature for the dump is 0x00000001919484D0
  2013-03-28 11:46:29.25 Server External dump process return code 0x20000001.
  External dump process returned no errors.

  2013-03-28 11:46:29.46 Server SQL Server Audit failed to record the SERVER SHUTDOWN action.

  Thursday, March 28, 2013 8:18 PM

• 

  Sign in to vote

  Hello,

  c0000005 means access violation. When this error occurs it generates a dump file that should be analyzed. Microsoft CSS could analyze it for you. I don’t know how to analyze that dump file.

  One thing you can try is disable any antivirus/security software on your computer, and try to install one more time.

  You can also examine the system error log at the operating system level (Control Panel -> Administrative Tools –> Event Viewer) looking for errors.

  Hope this helps.

  Regards,

  Alberto Morillo

  SQLCoffee.com

  • Edited by Alberto MorilloMVP Thursday, March 28, 2013 10:30 PM

  Thursday, March 28, 2013 10:27 PM

• 

  Sign in to vote

  I uninstalled Avira Antivirus and disabled the Windows Firewall. In addition whenever i want to add an exception to Windows Firewall and click the allow programs through a firewall button, nothing happens. I even set the rights for the Microsoft SQL Server folder for all users to have full control. I uninstalled the database engine again then reinstalled it. The same error occurred. I tried to unset the read only attribute on the Microsoft SQL Server but it kept resetting back to the read only attribute. I'm lost at this point. The event viewer gave me this info:

  Could not load the DLL security.dll, or one of the DLLs it references. Reason: 193(security.dll is not a valid Win32 application.).

  -

  EventData

  security.dll

  193(%1 is not a valid Win32 application.) - EventData c0000005 9F430000100000000B0000004D00490043004800410045004C002D0050004300000000000000

  Other warnings I found in eventviewer:

  A provider, SQLServerEventProvider, has been registered in the Windows Management Instrumentation namespace root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER to use the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.

  A provider, ReportingServicesWMIProvider, has been registered in the Windows Management Instrumentation namespace root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\V11 to use the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests

  A provider, ReportingServicesWMIProvider, has been registered in the Windows Management Instrumentation namespace root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\V11\admin to use the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.

  The source of the above warnings is WMI.
  

  • Edited by gamers542 Sunday, March 31, 2013 4:01 AM

  Sunday, March 31, 2013 3:45 AM

• 

  Sign in to vote

  Hello,

  Seems like a security software did something with the security properties on the disk partition.

  I would like to recommend you Microsoft Security Essentials. It is free and less invasive.

  Hope this helps.

  Regards,

  Alberto Morillo

  SQLCoffee.com

  
  

  • Edited by Alberto MorilloMVP Sunday, March 31, 2013 4:56 AM

  Sunday, March 31, 2013 4:56 AM

• 

  Sign in to vote

  I already have the software I needed to protect my computer (Sophos, Super Antispyware, Malwarebytes) . What you just told me doesn't tell me anything in regards to my error and fixing it. What do you suggest I do? Downloading MSE won't do anything and I'm not looking for a workaround. One other note: this started happening one I took WAMPServer off my computer.

  Sunday, March 31, 2013 5:14 AM

• 

  Sign in to vote

  Hello,

  I would recommend you to post about those errors/warnings on a Windows 7 forum. Maybe there you may find somebody to fix that disk partition for you.

  I am not sure if repairing Windows 7 could help.

  Hope this helps.

  Regards,

  Alberto Morillo

  SQLCoffee.com

  Sunday, March 31, 2013 5:24 AM

• 

  Sign in to vote

  Are you certain that it is a Win 7 OS error and not a SQL Server error only? Because nothing else I've installed has given me this problem before. So for now is SQL Server unusable for me?

  Sunday, March 31, 2013 5:46 AM

• 

  Sign in to vote

  Hello,

  Based on the following article, issues with security.dll may affect software installation:

  http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_update/installation-status-failed-security-update-for/fe81e7dd-2537-46b2-a099-e37ac2445620

  Asolution is provided.

  Hope this helps.

  Regards,

  Alberto Morillo

  SQLCoffee.com

  
  

  • Edited by Alberto MorilloMVP Monday, April 1, 2013 1:43 PM

  Sunday, March 31, 2013 3:45 PM

• 

  Sign in to vote

  It hasn't worked so far. The same database handle error keeps occurring with the same access violation error occurring again. One warning that keeps getting generated during installation is this:

  "Rule Firewall" generated a warning. Make sure the appropriate ports are open to enable remote access. See rules documentation for info. ..."

  Will this rule affect SQL Server in any way? I noticed that many people just ignore it.

  • Edited by gamers542 Monday, April 1, 2013 6:12 PM

  Monday, April 1, 2013 5:27 PM

• 

  Sign in to vote

  Hello,

  No that rule should not affect at all. It is not related to the issue.

  However, if you would like to get rid of that warning just disable Windows Firewall using Control Panel or configure it using the following article:

  http://msdn.microsoft.com/en-us/library/cc646023(v=sql.110).aspx

  Hope this helps.

  Regards,

  Alberto Morillo
  SQLCoffee.com

  Monday, April 1, 2013 6:38 PM

• 

  Sign in to vote

  I tried disabling the firewall, then I added a rule using the Windows Firewall with Advanced Settings feature. I followed the directions exactly then I reinstalled sql server again. It still failed with the exact errors again. I'm starting to wonder if Apache messed something up when I installed wampserver. The security.dll fixes didn't work either. It is still there as well. I even tried restoring my system to before I had both wamp and sql server installed. Again to no avail. Is there anything else to try aside from a factory reset?
  

  Tuesday, April 2, 2013 11:53 AM

• 

  Sign in to vote

  Hello,

  On Sunday I mentioned you to perform a Windows 7 repair. The following thread will explain you how to do that:

  
  http://www.sevenforums.com/tutorials/3413-repair-install.html

  Hope this helps.
  

  Regards,

  Alberto Morillo
  SQLCoffee.com

  Tuesday, April 2, 2013 12:14 PM