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 dialog with error code 42000.

SQL SERVER – sp_server_diagnostics – The User Does Not Have Permission to Perform this Action. (297)

June 5, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster

An AlwaysOn resource would not come online, and the cluster log showed sp_server_diagnostics failing with error 297, no permission. Here is the fix.

Read More
Two identical generators in a plant room, the standby one dark and its lamp unlit.

SQL SERVER – Clustered SQL Resource Not Coming Online

April 29, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Cluster

Clustered SQL resource stuck in online pending, yet the service started fine from services.msc. The cluster log showed a login failure. Here is the fix.

Read More
IP address properties dialog.

SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows Cluster

April 15, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Cluster

An availability group listener would not come online. The cluster log said unable to add server name to transport device NetBt_If4, status 2.

Read More
SQL Server 2016 setup process.

SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation

April 13, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL Setup

Stuck for hours on ‘Please wait while Microsoft SQL Server 2016 Setup process the current operation’? Detail.txt showed the cause of this slow installation.

Read More
Diagram of service pack setup calling MS_CLUSTER_PROVIDER with the resource type name Double-Take Source Connection, failing with StatusCode 4104, and the fix with Remove-ClusterResourceType

Double-Take Source Connection: Service Pack Fails to Look Up Cluster Resource Types

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

A SQL Server service pack failed in a cluster with an error to lookup cluster resource types. Detail.txt named the Double-Take Source Connection resource type. Removing it with Remove-ClusterResourceType fixed the install.

Read More
Diagram of an availability group and a Windows Server Failover Cluster: when the lease renewal fails, error 19407 appears and the group moves from PRIMARY_NORMAL and SECONDARY_NORMAL to RESOLVING_NORMAL

Error 19407: The Lease Between the Availability Group and the Cluster Expired

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

Error 19407 means the lease between an availability group and the Windows Server Failover Cluster has expired, and the group goes to Resolving. Here is what each ERRORLOG line says and what to look at first.

Read More
Gouache painting of a wooden shelf holding a row of identical slate-blue teacups, with one empty saucer at the end and a vermilion thread across it

Number of Cluster Nodes Error: Add Node Fails on Enterprise Edition

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

The number of cluster nodes error stopped a client from adding a second node, even on Enterprise edition. Detail.txt showed the edition as Invalid. The file setup uses to read the edition was missing from the Shared folder.

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

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