The error ‘An error occurred for a dependency of the feature causing the setup process for the feature to fail’ occurs while installing SQL server 2019 from a mounted ISO file.

Here at Bobcares, we have seen several such SQL related issues as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at the cause for this error and see how to fix it.

How we fix the error ‘An error occurred for a dependency of the feature causing the setup process for the feature to fail.’

Let’s see how our Support Engineers help our customers in resolving this error message.

1. You can copy the below MSI files from the SQL Server 2019 installation media onto a temporary folder on a local drive on your machine (i.e. c:\temp).

\1033_ENU_LP\x64\Setup\x64
sqlncli
msoledbsql
msodbcsql

Once you complete copying the above files, run each one of them and when prompted to select one of the “Modify”, “Repair” or “Delete” options, choose the “Modify” option.

Then ensure that you choose all components to be installed on the local hard drive.

Once the installation of sqlncli, msoledbsql and msodbcsql completes, restart the computer and try again to install SQL Server 2019.

2. Uninstall Old Versions of SQL Server Management Studio (SSMS)

Try uninstalling any versions of SSMS that are older than v18.3.1. Then restart the computer and try again to install SQL Server 2019.

3. Uninstall SQL Server 2012 Native Client

Normally, SQL Server 2012 Native Client gets installed along with SSMS. So, uninstall it, restart the computer and try again to install SQL Server 2019.

4. Copy all files from the installation media (i.e. from the mounted ISO file) to a temporary folder on your computer’s local drive. After that, launch SQL Server 2019 installation from your local drive and try again to install it.

5. Uninstall improperly installed SQL server and then try to install the SQL server once more.

Before uninstalling the current installation, ensure to follow the below steps:

1. Back up the data.

Make sure that you save the following database files:

master.mdf
msdbdata.mdf
Tempdb.mdf
mastlog.ldf
msdblog.ldf
Templog.ldf
model.mdf
Mssqlsystemresource.mdf
ReportServer[$InstanceName]
modellog.ldf
Mssqlsustemresource.ldf
ReportServer[$InstanceName]TempDB

2. Stop all the SQL Server services.

3. Use an account that has the appropriate permissions.

Follow the below steps to uninstall SQL Server from Windows 10, Windows Server 2016, Windows Server 2019, and greater.

1. First, navigate to Settings from the Start menu and then choose Apps.
2. Next, search for SQL in the search box.
3. Then select Microsoft SQL Server (Version) (Bit). For example, Microsoft SQL Server 2017 (64-bit).
4. Now select Uninstall.
5. Select Remove on the SQL Server dialog pop-up to launch the Microsoft SQL Server Installation wizard.
6. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove or specify the option to remove only the SQL Server shared features and management tools. Then continue by selecting Next.
7. On the Select Features page, specify the features to remove from the specified instance of SQL Server.
8. On the Ready to Remove page, review the list of components and features that you wish to uninstall. Then to begin the uninstalling process click Remove.
9. Refresh the Apps and Features window to verify the SQL Server instance has been successfully removed, and determine which, if any, SQL Server components still exist. Remove these components from this window as well, if you choose to.

[Need any assistance in fixing SQL errors? – We’ll help you]

Conclusion

In short, this error occurs while installing the SQL server 2019 from a mounted ISO file. Today, we saw the fix provided by our Support Engineers.