Share via

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..

Homer Sibayan 366 Reputation points
2023-01-17T12:13:39.11+00:00

Hi Experts,

For the first time, we install New SQL Failover clustering on primary host and it success, however when we tried to install now the SQL on the secondary host as Add node SQL failover cluster, we encountered an error at the beginning of the installation. "SQL Server Setup has encountered the following error: Failed to retrieve data for this request.

error

Our setup is to deploy 2 node windows 2019 failover clustering with SQL failover Cluster instance. (Basically 2 node cluster)

Done the following but none of them resolve the issue.

  1. Stared the "Remote Registry service" on the services for both hosts. (With this reference: [https://social.msdn.microsoft.com/Forums/en-US/d8f752af-416b-4460-8893-a412c2135a28/title-sql-server-setup-failure-sql-server-setup-has-encountered-the-following-error-failed?forum=sqlsetupandupgrade

https://social.msdn.microsoft.com/Forums/en-US/eeaf5af0-7c45-40ac-9970-e2ea25a88917/edit-setup-has-encountered-the-following-error-failed-to-retrieve-data-during-reinstallation?forum=sqlsetupandupgrade

  1. Reformat the affected secondary host and install fresh windows 2019 standard.
  2. Remove all related SQL server components in registry. in order to uninstall forcedly the SQL server 2019 standard on the machine. and tried to re-install it with correct setup.
  3. Restarted the machine many times.
  4. Check in Network Adapter "Enabled Printer and sharing.
  5. Updated to the latest version of windows. 2019.
  6. Rename the hostname of affected machine/host.

Please help us or if you have any recommendation.

check with this reference but no success.

Thanks in advance.

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

SQL Server Integration Services
SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

SQL Server | Other
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. eric p 5 Reputation points
    2025-08-22T19:37:43.6966667+00:00

    Had the same issue

    Went into services and started remote registry on both sides of the cluster.

    Restarted the CU update, and it all worked.

    1 person found this answer helpful.
  2. MARIO BORDAC 5 Reputation points
    2023-06-28T11:46:13.26+00:00

    You need to evict that problematic node from the cluster and it start to work. At least this is what helped me.

    1 person found this answer helpful.
  3. Raksha Chourasia 75 Reputation points
    2023-07-17T07:29:16.32+00:00

    Some things which will resolve your issue:

    1. Checking the network connectivity: Need to make sure while checking network connectivity between primary and secondary hosts.
    2. Validating the cluster configuration as it's set up correctly as well it's functioning properly.
    3. Verifying the user permissions: Need to make sure that you are installing the SQL server on secondary hosts.
    4. Validating prerequisites:: Need to check all requirements on the SQL server.
    5. Review setup and cluster logs.
    6. Check on disk configuration: Need to check on the disk configuration which is set up on the secondary hosts.

    For resolving this error you can also have a look at this article: https://learn.microsoft.com/en-us/troubleshoot/sql/ssms/error-click-databases-node

    I hope this would help!!

    0 comments
  4. LiHongMSFT-4306 31,621 Reputation points
    2023-01-18T06:26:03.3733333+00:00

    Hi @Homer Sibayan

    Could you please post the error logs.

    The location by default is: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log

    There is a summary.txt file and many subfolders created every time the Installation wizard is started. In those subfolders, we can find a Detail.txt file.

  5. Bjoern Peters 8,921 Reputation points
    2023-01-17T15:56:12.0033333+00:00

    Hi Homer,

    Your screenshot looks like you didn't get deep into the setup. The error already happened directly at the start...

    Please do me a favor, and try to get a new download of the ISO file for that server... DON'T copy it from an "older" server... get a new download and try the installation again.

    It happened to me from time to time that some bytes are lost during copy&paste, and then it gives you some strange errors during installation...

    I hope my answer is helpful to you,

    Your

    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

    0 comments

Your answer

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