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

Question

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.

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.

Answer 1

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

Answer 2

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!

Answer 3

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.

Answer 4

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!!