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
SQL Server error dialog box.

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 Tips and Tricks
AlwaysOn, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Configuration

After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.

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

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

February 6, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Management Studio

A client’s availability group showed in SSMS, but no role appeared in Failover Cluster Manager. Here is the sequence of steps that causes this and what to do.

Read More
RSAT-ClusterTools installed in PowerShell.

SQL SERVER – Patch Failure – Unable to Retrieve the Cluster Service

February 1, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Patch, SQL Server, SQL Server Cluster, SQL Server Services

Patching SQL Server 2008 R2 on a Windows Server 2012 cluster failed: unable to retrieve the Cluster Service. Here is what Detail.txt showed and the fix.

Read More
Gouache painting of boats resting on tidal sand with one vermilion boat waiting for the water

SQL Server Cluster Resource in Online Pending Too Long

January 30, 2019
Pinal Dave
SQL Tips and Tricks
SQL High Availability, SQL Log, SQL Server Cluster, VLF

A SQL Server cluster resource that stays in Online Pending for minutes can be waiting for database recovery. This post reads the cluster events and log lines of one case, finds an 8 minute gap, and traces it to a huge number of virtual log files that a log backup and a shrink fixed.

Read More
SQL SERVER - Always On Availability Group Listener Missing in SSMS but Working Fine in Failover Cluster Manager

SQL SERVER – Always On Availability Group Listener Missing in SSMS but Working Fine in Failover Cluster Manager

January 24, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Management Studio

My client’s AG listener worked fine in Failover Cluster Manager, yet SSMS showed nothing. Here is what causes a listener missing in SSMS and the fix.

Read More
Diagram of SQL Server cluster setup setting the folder permission on the DATA folder under a volume mount point and failing with HResult 0x84cf0003, with the ruled out causes and the real cause, the Audit Object Access policy from a GPO

0x84cf0003: Cluster Install Fails Updating Permission Setting for Folder

December 27, 2018
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Installation

A SQL Server cluster install failed with 0x84cf0003: Updating permission setting for folder failed. Service account rights and folder permissions were fine. The cause was the Audit Object Access policy from a GPO.

Read More
Gouache painting of a wooden shape-sorter box with a round vermilion peg resting beside a square hole on the lid

Set-ClusterParameter Error: ProbePort Does Not Exist on the Cluster Object

December 13, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, PowerShell, SQL Azure, SQL Error Messages, SQL Server Cluster

The Set-ClusterParameter error said Parameter ‘ProbePort’ does not exist on the cluster object. I hit it while setting up a probe port for an Always On listener in Azure. Two wrong values in my script were the cause, and fixing both let the script run.

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

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