[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Component error code 0x84BB0001 System Error

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Component error code 0x84BB0001 System Error.


Applies to: SQL Server 2019 Developer Edition, Windows 10 Home Edition.

Date created: September 21, 2020.
 

Problem Description.
 

One of my students asked for help installing SQL Server 2019. She shared with me the following summary (Summary.txt ) of the installation:


Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061527940
Start time: 2020-09-10 19:59:10
End time: 2020-09-10 20:30:10
Requested action: Install

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


Machine Properties:
Machine name: DESKTOP-1H0B8R2
Machine processor count: 1
OS version: Microsoft Windows 10 Home (10.0.19041)
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 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Developer Edition 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:\SQL2019\Developer_ENU\x64\setup\
Installation edition: Developer

Product Update Status:
None discovered.

Azul OpenJDK JRE installed. For information on Azul Zulu OpenJDK third party licensing, see https://www.azul.com/licenses-zulu-third-party-licenses/

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: <empty>
AGTSVCPASSWORD: <empty>
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 Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200910_195910\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FEATURES: REPLICATION, FULLTEXT, POLYBASECORE, POLYBASEJAVA, CONN, IS, BC
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT Service\MSSQLFDLauncher$DIANA
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACCEPTSQLSERVERLICENSETERMS: true
IACKNOWLEDGEENTCALLIMITS: 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: Diana
INSTANCENAME: DIANA
ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service
ISMASTERSVCPASSWORD: <empty>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <empty>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <empty>
ISSVCACCOUNT: NT Service\MsDtsServer150
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: NT Service\SSISTELEMETRY150
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: Automatic
ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service
ISWORKERSVCCERT: <empty>
ISWORKERSVCMASTER: <empty>
ISWORKERSVCPASSWORD: <empty>
ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
PBDMSSVCPASSWORD: <empty>
PBDMSSVCSTARTUPTYPE: Automatic
PBENGSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
PBENGSVCPASSWORD: <empty>
PBENGSVCSTARTUPTYPE: Automatic
PBPORTRANGE: 16450-16460
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:
SQLMAXDOP: 1
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT Service\MSSQL$DIANA
SQLSVCINSTANTFILEINIT: false
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <empty>
SQLTELSVCACCT: NT Service\SQLTELEMETRY
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: Normal
UpdateEnabled: true
UpdateSource: MU
USEMICROSOFTUPDATE: true
USESQLRECOMMENDEDMEMORYLIMITS: false
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200910_195910\ConfigurationFile.ini

Detailed results:
Feature: Full-Text and Semantic Extractions for Search
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 Full Text Search
Component error code: 0x84BB0001
Error description: System error.
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=0xB62E9E53%400x172BD4A2&EvtType=0xB62E9E53%400x172BD4A2

Feature: Java connector for HDFS data sources
Status: Passed

Feature: PolyBase Query Service for External Data
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 PolyBase
Component error code: -2147467261
Error description: Value cannot be null. Parameter name: path1
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=0xDEE84595%400x11428655&EvtType=0xDEE84595%400x11428655

Feature: SQL Server Replication
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: 0x851F947C
Error description: Found empty or null string for value SQLGroup under registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.DIANA\Setup
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=0xED168B5A%400xC652C608%401311%4038012&EvtType=0xED168B5A%400xC652C608%401311%4038012

Feature: Client Tools Backwards Compatibility
Status: Passed

Feature: Client Tools Connectivity
Status: Passed

Feature: Integration Services
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 Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200910_195910\SystemConfigurationCheck_Report.htm

 

Cause.


Component error code: 0x84BB0001 occurs under the following scenarios:

bulletRemnants of previous failed SQL Server installations still exist on your computer.
bulletSQL Server installation is corrupted, you may need to download the SQL Server media again, and try install SQL Server again.
bulletThe user did not have the permissions to access the register, you can grant full permissions to below registry keys to the setup account and SQL Service account.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\

About Component error code: -2147467261 with description "Value cannot be null. Parameter name: path1", this error usually goes away if you try the installation again, but it does not go away try downloading the media again and install from the newly downloaded media.

And for the Component error code: 0x851F947C with description "Found empty or null string for value SQLGroup under registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.DIANA\Setup" seems to me very predictable since the database engine failed to install correctly.

 

Solution.


 Try the following solutions/workarounds to install SQL Server successfully:

bullet Download the SQL Server again, and mount the ISO file as a virtual drive.
bullet Manually uninstall SQL Server remnants as explained in this article.
bullet What worked for my student was to run SQL Server setup again, and change the SQL Server service account and SQL Server Browser account to Local System on the Server Configuration page of SQL Server setup.
bullet Install it again, use administrator to open full installation media or run SQL Server setup as an Administrator. You may have to enable the Administrator account on Windows 10 as explained here.

 

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.