win server 2019 無法安裝SQL server 2012 Database Engine Services

在客戶的環境中(win server 2019)安裝SQL 2012無法安裝Database Engine Services

客戶說是因為win server 2019不支援SQL 2012，要win server 2012才可以

但我在我們家的測試環境中，win server 2019卻能正常安裝sql 2012，有在想是不是客戶的一些資安規範有擋，但客戶的IT說沒有...

詳細log如下:

Overall summary:

Final result: 失敗: 請參閱下面的詳細資料

Exit code (Decimal): -2068119551

Start time: 2022-08-30 14:09:36

End time: 2022-08-30 14:14:33

Requested action: Install

Setup completed with required actions for features.

Troubleshooting information for those features:

Next step for SQLEngine: 使用下列資訊解決錯誤，解除安裝這項功能，然後重新執行安裝程序。

Machine Properties:

Machine name: SNAXXXXX

Machine processor count: 16

OS version: Future Windows Version

OS service pack:

OS region: 台灣

OS language: 中文(繁體) (台灣)

OS architecture: x64

Process architecture: 64 位元

OS clustered: 否

Product features discovered:

Product Instance Instance ID Feature Language Edition Version Clustered Configured

Package properties:

Description: Microsoft SQL Server 2012

ProductName: SQL Server 2012

Type: RTM

Version: 11

SPLevel: 0

Installation location: C:\Temp\sql2012\SQL SERVER 2012 STD\x64\setup\

Installation edition: Standard

Product Update Status:

未探索到任何項目。

使用者輸入設定:

ACTION: Install

ADDCURRENTUSERASSQLADMIN: false

AGTSVCACCOUNT: NT Service\SQLSERVERAGENT

AGTSVCPASSWORD: *****

AGTSVCSTARTUPTYPE: Automatic

ASBACKUPDIR: Backup

ASCOLLATION: Latin1_General_CI_AS

ASCONFIGDIR: Config

ASDATADIR: Data

ASLOGDIR: Log

ASPROVIDERMSOLAP: 1

ASSERVERMODE: MULTIDIMENSIONAL

ASSVCACCOUNT: <空的>

ASSVCPASSWORD: <空的>

ASSVCSTARTUPTYPE: Automatic

ASSYSADMINACCOUNTS: <空的>

ASTEMPDIR: Temp

BROWSERSVCSTARTUPTYPE: Automatic

CLTCTLRNAME: <空的>

CLTRESULTDIR: <空的>

CLTSTARTUPTYPE: 0

CLTSVCACCOUNT: <空的>

CLTSVCPASSWORD: <空的>

CLTWORKINGDIR: <空的>

COMMFABRICENCRYPTION: 0

COMMFABRICNETWORKLEVEL: 0

COMMFABRICPORT: 0

CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20220830_140811\ConfigurationFile.ini

CTLRSTARTUPTYPE: 0

CTLRSVCACCOUNT: <空的>

CTLRSVCPASSWORD: <空的>

CTLRUSERS: <空的>

ENABLERANU: false

ENU: false

ERRORREPORTING: false

FEATURES: SQLENGINE

FILESTREAMLEVEL: 0

FILESTREAMSHARENAME: <空的>

FTSVCACCOUNT: <空的>

FTSVCPASSWORD: <空的>

HELP: false

IACCEPTSQLSERVERLICENSETERMS: true

INDICATEPROGRESS: false

INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\

INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\

INSTALLSQLDATADIR: <空的>

INSTANCEDIR: C:\Program Files\Microsoft SQL Server\

INSTANCEID: MSSQLSERVER

INSTANCENAME: MSSQLSERVER

ISSVCACCOUNT: NT AUTHORITY\Network Service

ISSVCPASSWORD: <空的>

ISSVCSTARTUPTYPE: Automatic

MATRIXCMBRICKCOMMPORT: 0

MATRIXCMSERVERNAME: <空的>

MATRIXNAME: <空的>

NPENABLED: 0

PID: *****

QUIET: false

QUIETSIMPLE: false

ROLE: <空的>

RSINSTALLMODE: DefaultNativeMode

RSSHPINSTALLMODE: DefaultSharePointMode

RSSVCACCOUNT: <空的>

RSSVCPASSWORD: <空的>

RSSVCSTARTUPTYPE: Automatic

SAPWD: *****

SECURITYMODE: SQL

SQLBACKUPDIR: <空的>

SQLCOLLATION: Chinese_Taiwan_Stroke_CI_AS

SQLSVCACCOUNT: NT Service\MSSQLSERVER

SQLSVCPASSWORD: <空的>

SQLSVCSTARTUPTYPE: Automatic

SQLSYSADMINACCOUNTS: AD\Admin

SQLTEMPDBDIR: <空的>

SQLTEMPDBLOGDIR: <空的>

SQLUSERDBDIR: <空的>

SQLUSERDBLOGDIR: <空的>

SQMREPORTING: false

TCPENABLED: 1

UIMODE: Normal

UpdateEnabled: true

UpdateSource: MU

X86: false

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

Detailed results:

Feature: Database Engine Services

Status: 失敗: 詳細資料請參閱記錄檔

Reason for failure: 功能的安裝程序期間發生錯誤。

Next Step: 使用下列資訊解決錯誤，解除安裝這項功能，然後重新執行安裝程序。

Component name: SQL Server Database Engine Services 執行個體功能

Component error code: 0x84BB0001 Error

description: 與伺服器的連接已成功建立，但在登入前的信號交換時發生錯誤。 (provider: 具名的管線提供者, error: 0 - 管道的另一端上無任何處理程序。)

Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.7507.2&EvtType=0xBA6E21AA%400x9A41B222&EvtType=0xBA6E21AA%400x9A41B222

Feature: SQL Browser

Status: 通過

Feature: SQL 寫入器

Status: 通過

Feature: SQL 用戶端連接性

Status: 通過

Feature: SQL 用戶端連接性 SDK

Status: 通過

Feature: 安裝程式支援檔案

Status: 通過

Rules with failures:

Global rules:

Scenario specific rules:

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