Possible Owners SQL server FCI

• samirca007

  SSC-Addicted

  Points: 417

  More actions

  August 14, 2019 at 1:50 pm

  #3671319

  Hello everyone ,

  at one of his clients for an audit assignment

  I have an FCI sql server cluster with two nodes

  on the icon Possible owners

  I have only one node enabled

  

  what will be the impact of having this configuration?

  • This topic was modified 5 years, 4 months ago by  samirca007.

  Attachments:

  You must be logged in to view attached files.

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  August 14, 2019 at 3:56 pm

  #3671356

  Having only one node selected as a Possible Owner means you cannot fail over from the N1 server to the N2 server.  If these are the only 2 nodes in the cluster I'd suggest you check both, and then set N1 to be the preferred one if that is what was meant to be done.

  https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/windows-server-failover-clustering-wsfc-with-sql-server?view=sql-server-2017