A client could not change listener properties with PowerShell and got “An error occurred opening resource”. Here is the T-SQL query I shared and what fixed it.
SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation
A cluster patch failed with The RPC server is too busy. The real cause was a stopped Remote Registry service on the other node, and why it was off.
SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists
SQL Server 2014 setup on a Windows 2012 cluster with mount points failed with Status Code 183: Cannot create a file when that file already exists.
SQL SERVER – sp_server_diagnostics – The User Does Not Have Permission to Perform this Action. (297)
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.
SQL SERVER – Clustered SQL Resource Not Coming Online
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.
SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows 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.
SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation
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.