SQL Cluster: There was a failure to call cluster code from a provider


Scenario:

You have had successfully configured SQL Server 2016 (or other version) cluster on the first node and tried to add the second node to the cluster, but with no luck:

“Microsoft.SqlServer.Configuration.Cluster.EnumerateClusterSupportedIPAddressResourcesAction” threw an exception during execution.Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The cluster group could not be determined for resource ‘Cluster IP Address’. Error: There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 4098. Description: Not found

  • Both servers running on Windows Server 2016
  • SAN and MPIO are configured
  • Cluster is up and running
  • Migration of cluster resources works fine
  • There are no network issues between the servers
  • You use appropriate user account for setting the cluster

Solution 1: 

If you don’t have Internet on servers and can’t update them, start SQL Server installation on the node with the lower build number. For example, my SQL01 node had 14393.2273 build, while SQL02 – 14393.447. So, I used SQL02 as a first cluster node, and then added SQL01 to the cluster.  In my case, such configuration was just for test/demo, so I can’t recommend that solution for production even if the cluster seems to work fine.

Solution 2:

Just update your servers and make sure that they all have the same build number. Then, run cluster validation report, it should be “green”. Re-run cluster setup wizard on the second node.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s