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
A strawberry plant rooting a runner in a small red pot, garden snips ready to cut the old stem

SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance

November 15, 2018
Pinal Dave
SQL Tips and Tricks
SQL High Availability, SQL Server, SQL Server Cluster

Moving to a new VLAN? These are the exact steps to change the IP addresses of the Windows cluster nodes and of a SQL Server failover cluster instance.

Read More
Gouache painting of a worker checking a blocked bridge between two database towers

Always On Listener Creation Fails: Attempt to Locate a Writable Domain Controller Failed

October 18, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Domain Controller, SQL Error Messages, SQL Server Cluster

Always On listener creation can fail because the cluster cannot finish its directory work. In a 2018 client case, the same failure hit three clusters. This post shows how to read the cluster event, check DNS and directory permissions, prestage the listener object and verify the result.

Read More
Gouache painting of two brass compasses lying side by side on a folded paper map, their needles pointing in different directions, one needle tip vermilion

HADRAG Error: Did Not Find the Instance to Connect in SqlInstToNodeMap Key

October 12, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL DMV, SQL Error Messages, SQL High Availability, SQL Server Cluster

The HADRAG error ‘Did not find the instance to connect in SqlInstToNodeMap key’ kept an Always On availability group offline after unexpected failovers. The cluster log pointed to a metadata mismatch. Dropping the group on the secondary and recreating it brought it back.

Read More
Gouache painting of two brass posts joined by a cream rope across an open doorway, a vermilion tassel hanging from the rope

Msg 5123: CREATE FILE Access Denied on TempDB After Disk Migration

August 25, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL TempDB, Windows

Msg 5123 with operating system error 5, Access is denied, kept SQL Server from starting on a cluster after a disk migration. TempDB files could not be created on the new drive. Giving the SQL Server service account Full Control on the folders fixes it.

Read More
Event Properties For Event 1135, Failover Clustering.

SQL SERVER – Event ID: 1135 – Cluster node ‘NodeName’ was Removed From the Active Failover Cluster Membership

June 28, 2018
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Server, SQL Server Cluster

Event ID 1135 says a cluster node was removed from the active failover cluster membership. Here is what a customer’s AlwaysOn setup taught me about it.

Read More
SQL Server database size.

SQL SERVER – Unable to Start SQL Resource in Cluster – HUGE Master Database!

June 26, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster, System Database

A client’s SQL Resource would not come online on either cluster node. The ERRORLOG showed a very slow recovery of a huge master database. Here is the fix.

Read More
Microsoft Cluster Service errors dialog box.

SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 3

June 8, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster

Part 3: one more reason SQL Server setup can fail the MSCS cluster verification errors rule during install or AddNode, as seen at a client, and the fix.

Read More
Previous 1 2 3 4 5 6 … 11 Next
  • Books
  • Testimonials
  • Privacy Policy

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