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
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
Gouache painting of folders crossing an interrupted bridge between database towers

UpdateHADRResource Failed to Version-Copy File: System.IO.IOException

February 10, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Server Cluster, SQL Setup

UpdateHADRResource failed during a 2017 SQL Server 2012 patch because Setup could not copy hadrres.dll while another process used it. This post shows how to read the setup log, check the file and its owner, and read the HADR state of an instance with tested queries and commands.

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
SQL SERVER - FIX Error - Cluster Network Name showing NETBIOS status as "The system cannot find the file specified"

SQL SERVER – FIX Error – Cluster Network Name showing NETBIOS status as “The system cannot find the file specified”

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

A Cluster Network Name would not come online and showed NETBIOS status ‘The system cannot find the file specified’. Which log to check and how we fixed it.

Read More
SQL SERVER - Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working

SQL SERVER – Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working

November 8, 2016
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster

A client added a new node to the Windows Cluster and their AlwaysOn databases stopped synchronizing. The culprit was a wizard default, and here is the fix.

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

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