SQL Server Single Instance FCI - Failover Error

  • I have the following setup.

    • 3 Node WSFC Cluster hosted on EC2 in three different Subnet
    • Installed Single Node SQL Server FCI on all of the three Server

    But When I try to move one of the Role from one node to another it gives me the following error:

    error

    It will be great if someone could help me to understand the error.

    My end goal is to create a Cluster such that I can move one instance (Role) from one Node to another across all of these 3 Node WSFC Cluster.

    • This topic was modified 1 month, 2 weeks ago by  Shivkumar.
  • When installing a clustered instance - you need to install SQL Server into the cluster on each node where you want that instance to be able to failover. From this error, it seems you have only installed on the 'current' node for that instance.

  • Is it because the node you are trying to switch to isn't allowed to be an owner of the cluster resources?  If you right-click on the Resource and look at Advanced Policies it will show which nodes can be owners

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply