Share via

An error occurred for a dependency of the feature causing the setup process for the feature to fail.

Biltz 131 Reputation points
2020-10-20T10:00:23.977+00:00

Hi,

I am facing below issue while trying to install SQLServer2019 on two node production cluster. I have done couple of installations on these servers earlier without any issue, but with this 4th installation i am getting this issue. But I am able to connect to the instance..

============================================

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

Detailed results:
Feature: Data Quality 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, 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 cannot be started, either because it is disabled or because it has no enabled devices associated with it.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4053.23&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

Feature: Full-Text and Semantic Extractions for Search
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, 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 cannot be started, either because it is disabled or because it has no enabled devices associated with it.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4053.23&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

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: 0x80004005
Error description: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4053.23&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

Feature: SQL Server Replication
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, 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 cannot be started, either because it is disabled or because it has no enabled devices associated with it.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4053.23&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

Rules with failures or warnings:

Global rules:
Warning Cluster_VerifyForWarnings The MSCS cluster has been validated but there are warnings in the MSCS cluster validation report, or some tests were skipped while running the validation. To continue, run validation from the Windows Cluster Administration tool to ensure that the MSCS cluster validation has been run and that the MSCS cluster validation report does not contain errors.
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\20201019_181739\SystemConfigurationCheck_Report.htm

=============================================

Please suggest33606-erro2.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,694 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,966 Reputation points Microsoft Vendor
    2020-10-21T02:40:20.027+00:00

    Hi @Biltz ,

    What is the version of your SSMS? SQL server 2019 installation may failed if SSMS 18.x( older than SSMS 18.3.1) installed. The error message occurred is same as these.

    Try the workaround:

    1. Uninstall any version of SSMS older than SSMS 18.3.1.
    2. Install a newer version of SSMS (18.3.1 or later). For the latest version, see Download SSMS.
    3. Install SQL Server 2019 (15.x) normally.

    If you want know more solutions, please refer to the MS blog SQL Server 2019 Installation Error - An error occurred for a dependency of the feature and MS document SQL Server installation may fail if SSMS 18.x is installed to get more information.

    If it is not work, please share us the information that Shashank mentioned for analysis.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments
  2. Biltz 131 Reputation points
    2020-10-21T06:11:28.217+00:00

    33927-erro1.jpgHello guys,

    Thanks for your update..

    @Shashank Singh - Yes, even the the window shows it failed.. but I can see the SQL Server(SID) gets created in cluster and is online. Only i cannot see is the SQL Server agent. Pls check the attachment.33926-erro1.jpg

    0 comments
  3. Biltz 131 Reputation points
    2020-10-21T06:13:55.783+00:00

    @CathyJi-MSFT -- One one cluster node, there was ssms 16 installed. I uninstalled it but even after uninstall the same error.
    The second node has ssms 18 is installed, but i am getting the same error.

    Confusion is that I have done around 3 installations on these nodes, but didnt get this error.. only with the 4th installation i am facing this issue.

  4. Shashank Singh 6,251 Reputation points
    2020-10-21T14:00:40.543+00:00

    Yes, even the the window shows it failed.. but I can see the SQL Server(SID) gets created in cluster and is online.

    So SQL Server service is visible that is great. Please see below article how to get SQL Server agent in Cluster GUI

    fix-sql-server-agent-on-windows-failover-cluster

    It is a detailed step by step article.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.