I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.
SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error
Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
Drop Failed for Availability Group: Failed to Destroy the WSFC Group (Error 41000 and 41081)
A drop failed for Availability Group message can describe a partial removal, where SQL Server and Windows clustering no longer agree. The tests here read the HADR state, show what errors 41000 and 41081 say and prove that SET ONLINE cannot open a database that sits in RESTORING.
ArgumentNullException: Value Cannot Be Null in SQL Server Setup
Value cannot be null was the message when a client’s automated SQL Server installs failed at random. Detail.txt named the parameter instanceName. The generated configuration file had no InstanceName for a default instance, and that is what setup choked on.
SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint
Error 9642 in the ERRORLOG: an error occurred in a Service Broker/Database Mirroring transport connection endpoint. Here is what caused it for my client.
Network-Related or Instance-Specific Error During SQL Server Installation
The network-related or instance-specific error is a wrapper message, and during a SQL Server 2014 RTM installation its cause was TLS compatibility. The tests here show how the same message appears for different failures, how to read the number inside it and how to check protocols and encryption.
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation
A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.