How to add dependencies for a Cluster Disk in SQL Failover Cluster?

MEERAN RIZVI 1 Reputation point
2022-01-28T06:41:00.103+00:00

Hello All,

I am trying to set IP Address & SQL Server Network Name as a dependency for my Cluster Disk in my environment through Powershell. I am getting the following error:

The command I tried to set dependencies:

Set-ClusterResourceDependency -Resource 'Cluster Disk 3' -Dependency "([SQL Network Name (SQl-FC)]) and ([IP Address (x.x.x.x)])"

Set-ClusterResourceDependency: An error occurred while setting the dependency relationship for the resource 'Cluster Disk 3'.
The cluster resource could not be found
At line:1 char:1

  • Set-ClusterResourceDependency -Resource 'Cluster Disk 3' -Dependency ...
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • CategoryInfo : ObjectNotFound: (:) [Set-ClusterResourceDependency], ClusterCmdletException
  • FullyQualifiedErrorId : ResourceNotFound,Microsoft.FailoverClusters.PowerShell.SetClusterResourceDependencyCommand

The Error says the Cluster Resource could not be found.
Verified with Get-ClusterResource command too.

Get-ClusterResource "Cluster Disk 3"

Name State OwnerGroup ResourceType

Cluster Disk 3 Online SQL Server (MSSQLSERVER) Physical Disk

Really Appreciate your help on this. Thanks in Advance.

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,362 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 39,351 Reputation points
    2022-01-28T17:50:44.283+00:00

    Hello @MEERAN RIZVI

    Have your tried to use the resource name with quotes " ?

    Set-ClusterResourceDependency -Resource "Cluster Disk 3" -Dependency "([SQL Network Name (SQl-FC)]) and ([IP Address (x.x.x.x)])"

    Reference: https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ee461029(v=technet.10)?redirectedfrom=MSDN

    Hope this helps with your query,

    -----------

    --If the reply is helpful, please Upvote and Accept as answer--