SQL Server Cluster Archives - SQL Authority with Pinal Dave

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

March 17, 2020

AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Security

In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.

SQL SERVER – Always On Listener Not Coming Online – Failed to Create New NBT Interface, Status 1450

February 21, 2020

Pinal Dave

SQL

Computer Network, SQL Error Messages, SQL Server, SQL Server Cluster

I would share my learning about fixing error “Failed to create new NBT interface, status 1450 “in cluster log while creating the “IP Address” resource.

SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5

February 8, 2020

Pinal Dave

SQL

AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster, Windows

I have written a few blogs where I explained a few issues about the failure of listener creation failure in a cluster. Let us learn about it.

SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5

January 21, 2020

Pinal Dave

SQL Tips and Tricks

AlwaysOn, Computer Network, SQL Error Messages, SQL Log, SQL Server, SQL Server Cluster, Windows

I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.

SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group

May 10, 2019

Pinal Dave

SQL

AlwaysOn, SQL Error Messages, SQL High Availability, SQL Restore, SQL Server, SQL Server Cluster

While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group. If you want any such assistance, you can hire me for quick consultation using On Demand offering.

SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.

March 2, 2019

Pinal Dave

SQL

AlwaysOn, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Configuration

Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node.”

SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?

February 6, 2019

Pinal Dave

SQL

AlwaysOn, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Management Studio, SSMS

One of my existing clients has sent me an interesting question. In this blog, I would share one interesting situation where my client has created an availability group and it was visible in SSMS, but no role was visible in failover cluster manager.