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

All those " A significant part of sql server process memory has been paged out. This may result in a performance degradation. " does not look good. How much RAM do you have in your machine? What else do you have running? Maybe there is a connection here with your memory pressure and why SQL 2012 does not start.

Let's try this. Open a command prompt window with Run as Administrator. Navigate to:
C:\Program Files\Microsoft SQL Server\MSSQL11.SQL 20212\MSSQL\Binn
At the command prompt enter:
sqlservr -s SQL2012
If everything is working normally, you will see a whole slew of output, because now SQL Server will print to the console window what it normally prints to the error log. But there is no error log, maybe we will only see an error message?

Answer 3

Summary.txt

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2147467259
Start time: 2020-09-01 00:34:32
End time: 2020-09-01 00:52:15
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 Configured
SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.50.1600.1 No Yes

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

Slipstream: True
SP Level 4

Product Update Status:
Success: KB 4018073

Product Updates Selected for Installation:
Title: Service Pack 4
Knowledge Based Article: KB 4018073
Version: 11.4.7001.0
Architecture: x64
Language: 1033

Update Source: D:\software\SQLUpdate

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\20200901_003220\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
ERRORREPORTING: false
FEATURES: SQLENGINE, SSMS, ADV_SSMS, SNAC_SDK
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTSQLSERVERLICENSETERMS: 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: MSSQL2012
INSTANCENAME: MSSQL2012
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: true
UpdateSource: D:\software\SQLUpdate
X86: false

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

Detailed results:
Feature: Management Tools - Complete
Status: Passed

Feature: Management Tools - Basic
Status: Passed

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: 0x80004005
Error description: The service did not respond to the start or control request in a timely fashion.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.7001.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

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\20200901_003220\SystemConfigurationCheck_Report.htm

Answer 4

There could be 2 things causing this issue

1. Permission issue
2. Due to previous failed installation some components are not removed and hence the issue is coming.

Can you remove the installation from "Add remove program" also remove the SQL Server files and folder. Do not touch registry if installation via add remove program finishes successfully.

Other thing is DO NOT slip stream SP4 just install SQL Server 2012 and let me know. This is strange request but please try it and let me know.

Answer 5

Hi MabelTe-0750,

Could you please check the detailed error message in the detail.txt?
Please refer to workaround in this article which might help.

Best Regards,
Amelia