SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue related to retrieve data.

One of my clients was installing Service Pack on a clustered SQL instance and it was failing. I looked into Detail.txt and found below information.

2017-02-28 11:03:44 Slp: Running Action: RunDiscoveryAction
2017-02-28 11:03:44 Slp: Running discovery on local machine
2017-02-28 11:03:47 Slp: Discovery on local machine is complete
2017-02-28 11:03:47 Slp: Running discovery on remote machine: SQLNODE-B
2017-02-28 11:05:21 Slp: Discovery on SQLNODE-B failed due to exception
2017-02-28 11:05:21 Slp: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. —> Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: The network path was not found.

Solarwinds

Based on my understanding of .net, the stack goes from bottom to top. If we look at functions called, it looks like a Registry call to get details from remote nodes. It seems that in order to complete the remote discovery, setup has to read the registry of the remote node. We attempted to open the registry on node SQLNODE-B from registry editor on node SQLNODE-A. (Start > run > Regedit)

SQL SERVER - Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request reg-remote-01

As soon as we gave the remote node name, it failed to open the registry and gave the same error.

SOLUTION/WORKAROUND

We realized that “Remote Registry” service was “Disabled” on remote node. Enabling that, solved the problem.

SQL SERVER - Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request reg-remote-02-800x344

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – Availability Group Missing or Deleted Automatically?
Next Post
SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

Related Posts

1 Comment. Leave new

  • whatif we are able to connect to remote server and still not be able to launch the servicepack. remote registry is running fine and restarted.

    Reply

Leave a Reply

Menu