Issue Adding Node to a SQL Server Failover Cluster – Greyed Out Service Account – How to Resolve

Hi friends! In this post, which is related to SQL Server failover clustering, we will talk about how you can resolve the issue of not being able to add a node to a Server failover cluster, due to the fact that one of the service accounts (i.e. SQL Server or SQL Server Agent, or both) … Read more…

How to Fix SQL Server Agent Not Showing in a Failover Cluster

Hi friends, in this post, we will discuss about how you can fix the issue, where SQL Server Agent might not be showing up in a SQL Server Failover Cluster Instance (FCI). SQL Server Agent not showing in Failover Cluster If you have a SQL Server failover cluster, and you cannot see SQL Server Agent … Read more…

Installing SSIS on a SQL Server Failover Cluster Instance

This short post, discusses about installing SSIS on a SQL Server Failover Cluster Instance and how you can resolve the error message: The instance selected for installation is already installed and clustered on computer [ComputerName]. To continue, select a different instance to cluster.   Reproducing the Error Message If you have already deployed a SQL … Read more…

The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group

So, you have a clustered SQL Server instance (FCI), you try to move (fail over) the entire role to another node of the cluster and you get the below error message: Error Code: 0x80071398 The operation failed because either the specified cluster node is not the owner of the group, or the node is not … Read more…

How to Enable SSL Certificate-Based Encryption on a SQL Server Failover Cluster

Hi folks. Because enabling an SSL certificate on a SQL Server Failover Cluster, thus enabling encryption for your data in-motion, is a little bit tricky, I decided to write this article in order to help you out a bit, since in the past, I encountered the same difficulties. So, please read on to learn more … Read more…

There is no SQL Server Failover Cluster Available to Join

If you are trying to add a new node to an existing SQL Server failover cluster and you are getting the error message “There is no SQL Server failover cluster available to join“, then you follow the below procedure for resolving the issue.   Procedure for Resolving the “There is no SQL Server Failover Cluster … Read more…

How to Patch a SQL Server Failover Cluster

This article discusses how to patch a SQL Server Failover Cluster. Patching SQL Server is one of the main administrative tasks in the DBA’s life. However, patching SQL Server is a procedure that needs to be planned, tested, and performed very carefully.     Below you can find a suggested methodology for patching a failover … Read more…