After release of SQL Server 2019, one of our customer was trying to install SQL Server 2019 and encountered an error message. Since I was able to reproduce the issue in my lab, I contacted SSMS product group and they were kind enough to fix this issue very quickly. As of now, this is already called out in the release notes. The purpose of this blog is to show how to confirm if you are hitting the same issue. We would learn how to look at various log file and what are the error messages we need to look.
Issue Description:
Installation of SQL Server 2019 from removable media fails if SQL Server Management Studio 18.3 or earlier is installed. In my lab, I downloaded ISO from download center and mounted it. Here is the final screen shot showing installation failure.
When we click on the hyperlink on the screen, it opens up setup summary file which has this information about failed component. (Database Engine Services)
Detailed results:
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Next step is to look at Detail.txt file for any hint about dependent feature. (Search for “at Microsoft” keyword)
Target package: «E:1033_ENU_LPx64setupx64sqlncli.msi»
InstallPackage: MsiInstallProduct returned the result code 1602.
No retry-able MSI return code detected.
ExecuteActionWithRetryHelper.Failed actionToExecute is ‘Install_sqlncli_Cpu64_Action’, stack trace at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClass2_0.<ExecuteActionWithRetryHelper>b__0()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClass2_0.<ExecuteActionWithRetryHelper>b__0()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClass2_0.<ExecuteActionWithRetryHelper>b__0()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClass2_0.<ExecuteActionWithRetryHelper>b__0()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
at Microsoft.SqlServer.Chainer.Setup.Setup.RunRequestedWorkflow()
at Microsoft.SqlServer.Chainer.Setup.Setup.Run(String[] args)
at Microsoft.SqlServer.Chainer.Setup.Setup.Start(String[] args)
at Microsoft.SqlServer.Chainer.Setup.Setup.Main()
Error: Action «Install_sqlncli_Cpu64_Action» failed during execution.
Completed Action: Install_sqlncli_Cpu64_Action, returned False…Trimmed lines…
MSI (s) (5C:3C) [06:42:01:134]: Note: 1: 1729
MSI (s) (5C:3C) [06:42:01:134]: Product: Microsoft SQL Server 2012 Native Client — Configuration failed.MSI (s) (5C:3C) [06:42:01:134]: Windows Installer reconfigured the product. Product Name: Microsoft SQL Server 2012 Native Client. Product Version: 11.4.7462.6. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 1602.
From here we can see that issue is during installation of SQLNCLI (SQL Server Native Client) and error code is 1602. The log file associate is sqlncli_Cpu64_1
MSI (s) (5C:3C) [06:42:01:009]: Note: 1: 2203 2: E:sqlncli.msi 3: -2147287038
MSI (s) (5C:3C) [06:42:01:009]: Source is incorrect. Unable to open or validate MSI package E:sqlncli.msi.
MSI (s) (5C:3C) [06:42:01:009]: Note: 1: 2203 2: E:sqlncli.msi 3: -2147287038
MSI (s) (5C:3C) [06:42:01:009]: Source is incorrect. Unable to open or validate MSI package E:sqlncli.msi.
Please insert the disk:
MSI (s) (5C:3C) [06:42:01:025]: Note: 1: 2265 2: 3: -2147287035
MSI (s) (5C:3C) [06:42:01:025]: User policy value ‘DisableRollback’ is 0
MSI (s) (5C:3C) [06:42:01:025]: Machine policy value ‘DisableRollback’ is 0
Action ended 6:42:01: InstallFinalize. Return value 2.
MSI (s) (5C:3C) [06:42:01:025]: Note: 1: 2318 2:
There we can see an interesting error : “Please insert the disk”.
If we check control panel, I already have SQL Server Native Client and mind you, this was installed when I installed SSMS 18.1.
Solution:
By now you would have understood the reason of the blog. If you are seeing messages in various logs, which are shown above, then you can conclude that you are hitting the issue due to preinstalled SSMS. Here is the screenshot from the release notes.
https://docs.microsoft.com/en-us/sql/sql-server/sql-server-version-15-release-notes
Here are my additional notes.
We have seen this issue earlier when we have SSMS 18.3 already installed and SQL 2019 setup is invoked from ISO mounted as drive. It was combination of few situations.
- SSMS 18.3 already installed AND
- SQL Server 2019 Setup was running from a mounted ISO.
We have below workarounds:
- On existing machines, where SSMS 18.3 or lower is already installed.
- Uninstall SQL Server 2012 Native Client which got installed with SSMS. Then install SQL Server 2019. OR
- Instead of running setup from mounted ISO, copy the content of media to a local drive or a network share and start setup.exe from those locations.
- On new machines, where SSMS is NOT installed.
- First install SQL Server 2019 and then install SSMS 18.3 OR
- Install version of SSMS greater than 18.3.1 and then install SQL Server 2019
I hope this blog would help someone find solution without contacting Microsoft Product Support team. Please comment and let me know.
- Cheers,
- Balmukund Lakhani
- Twitter @blakhani
Overall summary: Final result: Ошибка:
дополнительные сведения см. ниже Exit code (Decimal):
-2061893606 Start time: 2022-01-12 20:10:00 End time: 2022-01-12 20:15:40 Requested action:
Install
Setup completed with required actions for features. Troubleshooting
information for those features: Next step for FullText:
Устраните ошибку, пользуясь следующими сведениями, удалите компонент,
а затем запустите установку еще раз. Next step for SQLEngine:
Устраните ошибку, пользуясь следующими сведениями, удалите компонент,
а затем запустите установку еще раз. Next step for Replication:
Устраните ошибку, пользуясь следующими сведениями, удалите компонент,
а затем запустите установку еще раз.
Machine Properties: Machine name: DESKTOP-NJDBJCL
Machine processor count: 8 OS version:
Майкрософт Windows 11 Домашняя (10.0.22000) 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 2019 ProductName: SQL Server 2019 Type:
RTM Version: 15 SPLevel:
0 Installation location:
D:SQL2019ExpressAdv_RUSx64setup Installation edition:
Express
Product Update Status: Не обнаружено.
Параметры пользовательского ввода: ACTION:
Install ADDCURRENTUSERASSQLADMIN: true AGTSVCACCOUNT:
NT AUTHORITYNETWORK SERVICE AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Disabled ASBACKUPDIR:
Backup ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config ASDATADIR:
Data ASLOGDIR: Log ASPROVIDERMSOLAP:
1 ASSERVERMODE: TABULAR ASSVCACCOUNT:
<пусто> ASSVCPASSWORD: <пусто> ASSVCSTARTUPTYPE:
Automatic ASSYSADMINACCOUNTS: <пусто> ASTELSVCACCT:
<пусто> ASTELSVCPASSWORD: <пусто>
ASTELSVCSTARTUPTYPE: 0 ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME:
<пусто> CLTRESULTDIR: <пусто> CLTSTARTUPTYPE:
0 CLTSVCACCOUNT: <пусто> CLTSVCPASSWORD:
<пусто> CLTWORKINGDIR: <пусто>
COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0 CONFIGURATIONFILE:
CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT:
<пусто> CTLRSVCPASSWORD: <пусто> CTLRUSERS:
<пусто> ENABLERANU: true ENU:
false EXTSVCACCOUNT: <пусто> EXTSVCPASSWORD:
<пусто> FEATURES: SQLENGINE, REPLICATION,
FULLTEXT, CONN, BC, SDK, SNAC_SDK FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <пусто> FTSVCACCOUNT:
NT ServiceMSSQLFDLauncher FTSVCPASSWORD: <пусто>
HELP: false IACCEPTPYTHONLICENSETERMS:
false IACCEPTROPENLICENSETERMS: false
IACKNOWLEDGEENTCALLIMITS: false INDICATEPROGRESS:
false INSTALLSHAREDDIR: C:Program FilesMicrosoft SQL
Server INSTALLSHAREDWOWDIR: C:Program Files
(x86)Microsoft SQL Server INSTALLSQLDATADIR: <пусто>
INSTANCEDIR: D:Program FilesMicrosoft SQL Server
INSTANCEID: MSSQLSERVER INSTANCENAME:
MSSQLSERVER ISMASTERSVCACCOUNT: NT AUTHORITYNetwork
Service ISMASTERSVCPASSWORD: <пусто> ISMASTERSVCPORT:
8391 ISMASTERSVCSSLCERTCN: <пусто>
ISMASTERSVCSTARTUPTYPE: Automatic ISMASTERSVCTHUMBPRINT:
<пусто> ISSVCACCOUNT: NT AUTHORITYNetwork Service
ISSVCPASSWORD: <пусто> ISSVCSTARTUPTYPE:
Automatic ISTELSVCACCT: <пусто> ISTELSVCPASSWORD:
<пусто> ISTELSVCSTARTUPTYPE: 0 ISWORKERSVCACCOUNT:
NT AUTHORITYNetwork Service ISWORKERSVCCERT: <пусто>
ISWORKERSVCMASTER: <пусто> ISWORKERSVCPASSWORD:
<пусто> ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME:
<пусто> MATRIXNAME: <пусто> MRCACHEDIRECTORY:
NPENABLED: 0 PBDMSSVCACCOUNT:
<пусто> PBDMSSVCPASSWORD: <пусто>
PBDMSSVCSTARTUPTYPE: 0 PBENGSVCACCOUNT:
<пусто> PBENGSVCPASSWORD: <пусто>
PBENGSVCSTARTUPTYPE: 0 PBPORTRANGE:
<пусто> PBSCALEOUT: false PID:
***** QUIET: false QUIETSIMPLE: false ROLE: AllFeatures_WithDefaults
RSINSTALLMODE: DefaultNativeMode RSSVCACCOUNT:
<пусто> RSSVCPASSWORD: <пусто> RSSVCSTARTUPTYPE:
Automatic SAPWD: <пусто> SECURITYMODE:
<пусто> SQLBACKUPDIR: <пусто> SQLCOLLATION:
Cyrillic_General_CI_AS SQLJAVADIR: <пусто>
SQLMAXDOP: 0 SQLMAXMEMORY:
2147483647 SQLMINMEMORY: 0 SQLSVCACCOUNT:
NT AUTHORITYСИСТЕМА SQLSVCINSTANTFILEINIT: false
SQLSVCPASSWORD: ***** SQLSVCSTARTUPTYPE:
Automatic SQLSYSADMINACCOUNTS: DESKTOP-NJDBJCLKonnv
SQLTELSVCACCT: NT ServiceSQLTELEMETRY
SQLTELSVCPASSWORD: <пусто> SQLTELSVCSTARTUPTYPE:
Automatic SQLTEMPDBDIR: <пусто>
SQLTEMPDBFILECOUNT: 1 SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR:
<пусто> SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE:
8 SQLUSERDBDIR: <пусто> SQLUSERDBLOGDIR:
<пусто> SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED:
0 UIMODE: AutoAdvance UpdateEnabled:
true UpdateSource: MU USEMICROSOFTUPDATE:
false USESQLRECOMMENDEDMEMORYLIMITS: false X86:
false
Configuration file: C:Program FilesMicrosoft SQL
Server150Setup BootstrapLog20220112_200922ConfigurationFile.ini
Detailed results: Feature: Полнотекстовый и
семантический поиск Status: Сбой Reason for
failure: Возникла ошибка для одной из зависимостей
компонента, вызвавшая сбой процесса его установки. Next Step:
Устраните ошибку, пользуясь следующими сведениями, удалите компонент,
а затем запустите установку еще раз. Component name:
Экземпляры служб ядра СУБД SQL Server Component error code:
0x851A001A Error description: Ошибка при ожидании
дескриптора восстановления ядра СУБД. Возможные причины см. в журнале
ошибок SQL Server. Error help link:
https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026
Feature: Службы ядра СУБД Status:
Сбой Reason for failure: Возникла ошибка при установке
компонента. Next Step: Устраните ошибку,
пользуясь следующими сведениями, удалите компонент, а затем запустите
установку еще раз. Component name: Экземпляры служб
ядра СУБД SQL Server Component error code: 0x851A001A
Error description: Ошибка при ожидании дескриптора
восстановления ядра СУБД. Возможные причины см. в журнале ошибок SQL
Server. Error help link:
https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026
Feature: Репликация SQL Server Status:
Сбой Reason for failure: Возникла ошибка для одной из
зависимостей компонента, вызвавшая сбой процесса его установки. Next
Step: Устраните ошибку, пользуясь следующими
сведениями, удалите компонент, а затем запустите установку еще раз.
Component name: Экземпляры служб ядра СУБД SQL Server
Component error code: 0x851A001A Error description:
Ошибка при ожидании дескриптора восстановления ядра СУБД. Возможные
причины см. в журнале ошибок SQL Server. Error help link:
https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026
Feature: Обозреватель SQL Status:
Пройдено
Feature: Модуль записи SQL Status:
Пройдено
Feature: Обратная совместимость клиентских
средств Status: Пройдено
Feature: Пакет SDK клиентских средств
Status: Пройдено
Feature: Соединение с клиентскими средствами
Status: Пройдено
Feature: Пакет SDK средств связи клиента SQL
Status: Пройдено
Feature: Средства связи клиента SQL Status:
Пройдено
Feature: Файлы поддержки программы установки
Status: Пройдено
Rules with failures or warnings:
Global rules: Предупреждение IsFirewallEnabled
Брандмауэр Windows включен. Чтобы обеспечить удаленный доступ,
убедитесь, что открыты соответствующие порты. Сведения о портах,
которые необходимо открыть для каждого из компонентов, см. в
документации по правилам на странице
https://go.microsoft.com/fwlink/?linkid=2094702.
Rules report file: C:Program FilesMicrosoft SQL
Server150Setup
BootstrapLog20220112_200922SystemConfigurationCheck_Report.htm
Your privacy
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.
Here’s the summary log:
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068119551
Start time: 2020-04-29 10:12:58
End time: 2020-04-29 10:13:47
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: LAPTOP-ATGKGLE5
Machine processor count: 8
OS version: Microsoft Windows 10 Home (10.0.17763)
OS service pack:
OS region: Singapore
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 2017 SQLEXPRESS02 MSSQL14.SQLEXPRESS02 Database Engine Services 1033
Express Edition 14.0.1000.169 No Yes
SQL Server 2019 SQLEXPRESS MSSQL15.SQLEXPRESS Database Engine Services 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 SQLEXPRESS01 MSSQL15.SQLEXPRESS01 Database Engine Services 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER SQL Server Replication 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Express
Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Machine Learning Services and Language Extensions 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER AdvancedAnalyticssql_inst_mr 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER AdvancedAnalyticssql_inst_mpy 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER AdvancedAnalyticssql_inst_java 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Azul-Java-Runtime 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 SQLEXPRESS03 MSSQL15.SQLEXPRESS03 Database Engine Services 1033
Express Edition 15.0.2000.5 No Yes
SQL Server 2019 Client Tools Connectivity
1033 15.0.2000.5 No Yes
SQL Server 2019 Client Tools Backwards Compatibility
1033 15.0.2000.5 No Yes
SQL Server 2019 Client Tools SDK
1033 15.0.2000.5 No
Yes
Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation location: C:SQL2019Express_ENUx64setup
Installation edition: Express
Product Update Status:
User selected not to include product updates.
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: true
AGTSVCACCOUNT: NT AUTHORITYNETWORK SERVICE
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Disabled
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: TABULAR
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTELSVCACCT: <empty>
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: 0
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 FilesMicrosoft SQL Server150Setup BootstrapLog20200429_101258ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: true
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACCEPTSQLSERVERLICENSETERMS: true
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: true
INSTALLSHAREDDIR: C:Program FilesMicrosoft SQL Server
INSTALLSHAREDWOWDIR: C:Program Files (x86)Microsoft SQL Server
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:Program FilesMicrosoft SQL Server
INSTANCEID: SQLEXPRESS04
INSTANCENAME: SQLEXPRESS04
ISMASTERSVCACCOUNT: NT AUTHORITYNetwork Service
ISMASTERSVCPASSWORD: <empty>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <empty>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <empty>
ISSVCACCOUNT: NT AUTHORITYNetwork Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: <empty>
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: 0
ISWORKERSVCACCOUNT: NT AUTHORITYNetwork Service
ISWORKERSVCCERT: <empty>
ISWORKERSVCMASTER: <empty>
ISWORKERSVCPASSWORD: <empty>
ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: <empty>
PBDMSSVCPASSWORD: <empty>
PBDMSSVCSTARTUPTYPE: 0
PBENGSVCACCOUNT: <empty>
PBENGSVCPASSWORD: <empty>
PBENGSVCSTARTUPTYPE: 0
PBPORTRANGE: <empty>
PBSCALEOUT: false
PID: *****
QUIET: true
QUIETSIMPLE: false
ROLE: AllFeatures_WithDefaults
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLJAVADIR: <empty>
SQLMAXDOP: 0
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT ServiceMSSQL$SQLEXPRESS04
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: LAPTOP-ATGKGLE5User
SQLTELSVCACCT: NT ServiceSQLTELEMETRY$SQLEXPRESS04
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 1
SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8
SQLTEMPDBLOGDIR: <empty>
SQLTEMPDBLOGFILEGROWTH: 64
SQLTEMPDBLOGFILESIZE: 8
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 0
UIMODE: AutoAdvance
UpdateEnabled: false
UpdateSource: MU
USEMICROSOFTUPDATE: false
USESQLRECOMMENDEDMEMORYLIMITS: false
X86: false
Configuration file: C:Program FilesMicrosoft SQL Server150Setup BootstrapLog20200429_101258ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed
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: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.2000.5&EvtType=0x476BF04A%400xBB814387&EvtType=0x476BF04A%400xBB814387
Rules with failures or warnings:
Global rules:
Warning IsFirewallEnabled The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at https://go.microsoft.com/fwlink/?linkid=2094702
for information about ports to open for each feature.
Rules report file: C:Program FilesMicrosoft SQL Server150Setup BootstrapLog20200429_101258SystemConfigurationCheck_Report.htm
On a brand new install of Windows Server 2022 standard, I am trying to install SQL Server 2019.
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default instance. Tried both mixed and windows auth.
I have tried many of the different service accounts.
- Default
- NT AuthoritySYSTEM
- NT AUTHORITYLOCAL SERVICE
- NT AUTHORITYNETWORK SERVICE
At the end of the install, I still get the same error: «Wait on the Database Engine recovery handle failed».
TITLE: Microsoft SQL Server 2019 Setup
------------------------------
The following error has occurred:
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254026
------------------------------
BUTTONS:
OK
------------------------------
Each time I have tried uninstalling SQL Server, reinstalled and tried another account type. I have also tried setting the account no the SQL Server process itself to different account types but nothing is working. I have tried everything listed here too but nothing gets the installer to succeed.
Is anyone else able to install SQL Server 2019 on Windows Server 2022? It should be supported but this is crazy that it won’t install.
There is literally nothing else installed on this machine.
Some logs:
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061893606
Start time: 2021-10-14 12:00:52
End time: 2021-10-14 12:13:30
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: WEB02
Machine processor count: 32
OS version: Microsoft Windows Server 2022 Standard (10.0.20348)
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
Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation location: C:SQL2019Evaluation_ENUx64setup
Installation edition: Standard
Product Update Status:
None discovered.
Notice: A paid SQL Server edition product key has been provided for the current action - Standard. Please ensure you are entitled to this SQL Server edition with proper licensing in place for the product key (edition) supplied.
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: NT ServiceSQLSERVERAGENT
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: TABULAR
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTELSVCACCT: <empty>
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: 0
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 FilesMicrosoft SQL Server150Setup BootstrapLog20211014_120026ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:Program FilesMicrosoft SQL Server
INSTALLSHAREDWOWDIR: C:Program Files (x86)Microsoft SQL Server
INSTALLSQLDATADIR: F:Microsoft SQL Server
INSTANCEDIR: C:Program FilesMicrosoft SQL Server
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISMASTERSVCACCOUNT: NT AUTHORITYNetwork Service
ISMASTERSVCPASSWORD: <empty>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <empty>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <empty>
ISSVCACCOUNT: NT AUTHORITYNetwork Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: <empty>
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: 0
ISWORKERSVCACCOUNT: NT AUTHORITYNetwork Service
ISWORKERSVCCERT: <empty>
ISWORKERSVCMASTER: <empty>
ISWORKERSVCPASSWORD: <empty>
ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: <empty>
PBDMSSVCPASSWORD: <empty>
PBDMSSVCSTARTUPTYPE: 0
PBENGSVCACCOUNT: <empty>
PBENGSVCPASSWORD: <empty>
PBENGSVCSTARTUPTYPE: 0
PBPORTRANGE: <empty>
PBSCALEOUT: false
PID: *****
QUIET: false
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLJAVADIR: <empty>
SQLMAXDOP: 8
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT ServiceMSSQLSERVER
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: WEB02Administrator
SQLTELSVCACCT: NT ServiceSQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 8
SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8
SQLTEMPDBLOGDIR: <empty>
SQLTEMPDBLOGFILEGROWTH: 64
SQLTEMPDBLOGFILESIZE: 8
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 1
UIMODE: Normal
UpdateEnabled: true
UpdateSource: MU
USEMICROSOFTUPDATE: false
USESQLRECOMMENDEDMEMORYLIMITS: false
X86: false
Configuration file: C:Program FilesMicrosoft SQL Server150Setup BootstrapLog20211014_120026ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed
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: 0x851A001A
Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026
Feature: SQL Browser
Status: Passed
Feature: SQL Writer
Status: Passed
Feature: SQL Client Connectivity SDK
Status: Passed
Feature: SQL Client Connectivity
Status: Passed
Rules with failures or warnings:
Global rules:
Warning IsFirewallEnabled The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at https://go.microsoft.com/fwlink/?linkid=2094702 for information about ports to open for each feature.
Rules report file: C:Program FilesMicrosoft SQL Server150Setup BootstrapLog20211014_120026SystemConfigurationCheck_Report.htm
2021-10-14 12:08:14.01 Server Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: )
2021-10-14 12:08:14.01 Server UTC adjustment: 2:00
2021-10-14 12:08:14.01 Server (c) Microsoft Corporation.
2021-10-14 12:08:14.01 Server All rights reserved.
2021-10-14 12:08:14.01 Server Server process ID is 2872.
2021-10-14 12:08:14.01 Server System Manufacturer: 'ASUS', System Model: 'System Product Name'.
2021-10-14 12:08:14.01 Server Authentication mode is WINDOWS-ONLY.
2021-10-14 12:08:14.01 Server Logging SQL Server messages in file 'F:Microsoft SQL ServerMSSQL15.MSSQLSERVERMSSQLLogERRORLOG'.
2021-10-14 12:08:14.01 Server The service account is 'NT ServiceMSSQLSERVER'. This is an informational message; no user action is required.
2021-10-14 12:08:14.01 Server Registry startup parameters:
-d F:Microsoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAmaster.mdf
-e F:Microsoft SQL ServerMSSQL15.MSSQLSERVERMSSQLLogERRORLOG
-l F:Microsoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAmastlog.ldf
2021-10-14 12:08:14.01 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
2021-10-14 12:08:14.01 Server SQL Server detected 1 sockets with 16 cores per socket and 32 logical processors per socket, 32 total logical processors; using 32 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2021-10-14 12:08:14.01 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2021-10-14 12:08:14.01 Server Detected 130982 MB of RAM. This is an informational message; no user action is required.
2021-10-14 12:08:14.01 Server Using conventional memory in the memory manager.
2021-10-14 12:08:14.01 Server Page exclusion bitmap is enabled.
2021-10-14 12:08:14.16 Server Buffer Pool: Allocating 33554432 bytes for 20957208 hashPages.
2021-10-14 12:08:14.40 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2021-10-14 12:08:14.40 Server Automatic soft-NUMA was enabled because SQL Server has detected hardware NUMA nodes with greater than 8 physical cores.
2021-10-14 12:08:14.42 Server Buffer pool extension is already disabled. No action is necessary.
2021-10-14 12:08:14.43 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2021-10-14 12:08:14.44 Server Query Store settings initialized with enabled = 1,
2021-10-14 12:08:14.44 Server The maximum number of dedicated administrator connections for this instance is '1'
2021-10-14 12:08:14.44 Server This instance of SQL Server last reported using a process ID of 8512 at 10/14/2021 12:08:11 PM (local) 10/14/2021 10:08:11 AM (UTC). This is an informational message only; no user action is required.
2021-10-14 12:08:14.45 Server Node configuration: node 0: CPU mask: 0x0000000055555555:0 Active CPU mask: 0x0000000055555555:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2021-10-14 12:08:14.45 Server Node configuration: node 1: CPU mask: 0x00000000aaaaaaaa:0 Active CPU mask: 0x00000000aaaaaaaa:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2021-10-14 12:08:14.49 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.
2021-10-14 12:08:14.49 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2021-10-14 12:08:14.50 Server In-Memory OLTP initialized on standard machine.
2021-10-14 12:08:14.50 Server [INFO] Created Extended Events session 'hkenginexesession'
2021-10-14 12:08:14.50 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2021-10-14 12:08:14.50 Server Total Log Writer threads: 4. This is an informational message; no user action is required.
2021-10-14 12:08:14.53 Server Database Mirroring Transport is disabled in the endpoint configuration.
2021-10-14 12:08:14.53 Server clwb is selected for pmem flush operation.
2021-10-14 12:08:14.53 spid12s Warning ******************
2021-10-14 12:08:14.53 spid12s SQL Server started in single-user mode. This an informational message only. No user action is required.
2021-10-14 12:08:14.54 spid12s Starting up database 'master'.
2021-10-14 12:08:14.55 spid12s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file F:Microsoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAmaster.mdf.
2021-10-14 12:08:14.56 Server CLR version v4.0.30319 loaded.
2021-10-14 12:08:14.65 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:WindowsMicrosoft.NETFramework64v4.0.30319.
C: (where SQL is installed)
F: (where the data and log files are set to go)
Detail.txt (https://pastebin.com/3YGx1Dtn) from: C:Program FilesMicrosoft SQL Server150Setup BootstrapLog20211023_000906