sql server cluster

NeophyteSQL 241 Reputation points
2021-02-08T15:36:13.167+00:00

one of the nodes in our cluster had hardware failure

the node cannot be evicted.

if the cluster is destroyed using the destroy cluster option, will the sql server cluster name be lost.

will the applications have to now connect using the actual sql server name as opposed to the virtual name

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,851 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,606 Reputation points
    2021-02-09T02:55:11.757+00:00

    Hi,

    >the node cannot be evicted.

    To recover from the Hardware failure, remove the failed node from the failover cluster using the SQL Server Setup program, address the hardware failure with the computer offline, bring the machine back up, and then add the repaired node back to the failover cluster instance.

    More details please refer to following document:
    https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/failover-cluster-troubleshooting?view=sql-server-ver15#recovering-from-failover-cluster-failure

    0 comments No comments

  2. Shashank Singh 6,246 Reputation points
    2021-02-09T09:40:31.61+00:00

    the node cannot be evicted.

    The nodes in most cases can be evicted. Use command prompt do not use cluster GUI.

    PS C:\> import-module failoverclusters  
    PS C:\> Remove-ClusterNode -Name node_name -Force  
    PS C:\> clear-clusternode  
      
      
    

    Above 3 commands will help you remove cluster node and clear its information. node_name is node name of node which you want to evict.
    After you run clear-clusternode it will ask you confirmation and then give YES.

    if the cluster is destroyed using the destroy cluster option, will the sql server cluster name be lost.

    Again doing this from cluster GUI may not give you proper result, use below command to remove cluster and its copy from all its node and also the object from AD. Its documented

    PS C:\> Get-Cluster -Name Cluster1 | Remove-Cluster -Force -CleanupAD  
    

    will the applications have to now connect using the actual sql server name as opposed to the virtual name

    If SQL FCI is destroyed by removing it from add remove program you cannot use Virtual name, you have to reinstall SQL Server and then connect.

    0 comments No comments

  3. NeophyteSQL 241 Reputation points
    2021-03-04T04:05:44.18+00:00

    I receive an error

    you do not have admin proveleges on the cluser

    I know I am the admin on the node I am on, the other node is down.


  4. NeophyteSQL 241 Reputation points
    2021-03-04T14:27:01.713+00:00

    the complete error from powershell says:

    you do not have administrative privileges on the cluster, contact your network admin to request access

    Do i need domain admin access


  5. NeophyteSQL 241 Reputation points
    2021-03-05T17:42:21.56+00:00

    run as admin

    execute the command

    nothing happens
    it just sits there
    node is still there when viewed from cluster manager