Failure to install Database Enginee Service for SQL Server Standard 2012 on Windows 10

Question

I have problem in getting Database Engine Services installed for SQL Standard 2012 on Window 10. Have google and tried many ways, but encounter many different error.
I am writing this post after 2 weeks of research.... appreciate all help

1. Complete uninstall and fresh install again (that means remove program from Control Panel, delete regedit related to SQL Server 2012, delete all Microsoft SQL folder)
2. Install SQL Standard 2012 SP1, SP2, SP3, SP4, setting server configuration for SQL Server Database Engine to NT Service\System
3. Install 2018 to ensure a instance can be created. But when I installed 2012, encounter error "The service did not respond to the start or control request in a timely fashion" (I then tried to add DWORD - ServicesPipeTimeout to set as 180000
4. Install SQL 2012 Cumulative Update 3 and .Net 3.5 SP1
5. Install via command Setup.exe /ConfigurationFile= ConfigurationFile.ini

I just did another fresh install again (uninstall and install with regedit clear and SQL folder deleted) to prepare for any help. Following is what I have installed

• Under Apps & features, I have the following SQL version installed
• Microsoft SQL Server 2008 R2 (64 bit)
• Microsoft SQL Server 2012 (64 bits) with SP 1 to 4 installed
• .Net version 3.5 with SP1
• Windows Update has all the latest update i.e. "Check for update" has no outstanding program

Please advise. Thanks

Answer 1

I'm leaning towards that Avecto Defendpoint Service (which is what appears to have produced that event log message) decided that it was not approriate to start SQL Server 2012. Maybe it needs to be white-listed?

I think you need to talk with your internal IT folks at NCS to get this sorted out.

Answer 2

Summary.txt

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061893608
Start time: 2020-09-03 00:27:35
End time: 2020-09-03 00:35:18
Requested action: Install

Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

Machine Properties:
Machine name: NCS-270720DN02
Machine processor count: 8
OS version: Future Windows Version
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered

Package properties:
Description: Microsoft SQL Server 2012
ProductName: SQL Server 2012
Type: RTM
Version: 11
SPLevel: 0
Installation location: e:\x64\setup\
Installation edition: Standard

Product Update Status:
User selected not to include product updates.

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: MULTIDIMENSIONAL
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME: <empty>
CLTRESULTDIR: <empty>
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CLTWORKINGDIR: <empty>
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20200903_002611\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
ERRORREPORTING: false
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT AUTHORITY\Network Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
NPENABLED: 0
PID: *****
QUIET: false
QUIETSIMPLE: false
ROLE: <empty>
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: DefaultSharePointMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: NCS\P0102881
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: false
TCPENABLED: 1
UIMODE: Normal
UpdateEnabled: false
UpdateSource: MU
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20200903_002611\ConfigurationFile.ini

Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x851A0018
Error description: Could not find the Database Engine startup handle.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4024&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4024

Feature: SQL Browser
Status: Passed

Feature: SQL Writer
Status: Passed

Feature: SQL Client Connectivity
Status: Passed

Feature: SQL Client Connectivity SDK
Status: Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20200903_002611\SystemConfigurationCheck_Report.htm

Answer 3

" Could not find the Database Engine startup handle."

This means the same thing as the error in the original attempt. But it is more familiar to me. :-)

It means that SQL Server did not start properly when Setup wanted to start SQL Server. There are several possible reasons, although one appears to be more common than others, which will cause some people jump the gun and say "do this!".

But before we do there, we need to see the contents of C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\LOG\ERRORLOG. This file will tell us why SQL Server did not start.

Answer 4

Dear All,
There is no files in the folder: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log

So, I have no ERRORLOG to share for findings.

Answer 5

Hi All,
Following shows I do not have ERRORLOG. I have also search my C and D drive, but could not find any ERRORLOG also. For your kind advise. Thanks