This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Node A, Node B.

SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types

April 8, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Cluster, SQL Service Pack

A service pack install in a cluster failed with: There was an error to lookup cluster resource types. Detail.txt pointed to the cause. Here is the fix.

Read More
Diagram of servers and database clusters.

SQL SERVER – The Lease between Availability Group ‘PRODAG’ and the Windows Server Failover Cluster has Expired

March 27, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster

The lease between availability group and the Windows Server Failover Cluster has expired: a common error. Here is what each ERRORLOG line means.

Read More
Title card: Edition Does Not Support Number of Cluster Nodes

SQL SERVER – Add Failover Cluster Node Fails With Error – This SQL Server Edition Does Not Support the Installed Number of Cluster Nodes

March 3, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster

Add Failover Cluster Node failed: this SQL Server edition does not support the installed number of cluster nodes. What Detail.txt showed and how to fix it.

Read More
Error 19456 SQL Server Management Studio.

SQL SERVER – FIX: Error 19456: None of the IP Addresses Configured for the Availability Group Listener can be Hosted by the Server

February 13, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL High Availability, SQL Server, SQL Server Cluster

Deploying a hybrid AlwaysOn availability group across on-premises and Azure, adding a replica failed with error 19456. Here is what fixed it.

Read More
Cluster Network Unavailable In Fcm.

SQL SERVER – Why Cluster Network is Unavailable in Failover Cluster Manager?

January 12, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster

A Windows admin told me how cluster networks showed as unavailable in Failover Cluster Manager, and why a reboot was the fix that time.

Read More
SQL Server 2008 Properties Window.

SQL SERVER – Error After Cluster Patching – Error: 5184, Severity: 16, State: 2

December 13, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster

SQL Server would not come online after a service pack on a cluster. Here is how ERRORLOG helped me fix this error after cluster patching (error 5184).

Read More
SQL SERVER - Clustered Instance Online Error - SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]

SQL SERVER – Clustered Instance Online Error – SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]

December 12, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster

After a lab restart, the SQL resource stayed Online Pending, then Failed. Here is how the cluster log helped me fix this clustered instance online error.

Read More
Previous 1 … 5 6 7 8 9 10 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com