The AlwaysOn wizard said auto close is enabled, so the database can’t join an availability group. Here is why, and the settings to change first.
Visual Studio 2010 Shell Error During SQL Server Patching: Missing Package
A Visual Studio 2010 Shell error interrupted a SQL Server patch in a 2017 case. The setup screen named the component, but the component log named the missing package. This post shows how to read the logs, decode the Windows Installer error and match the package before any repair.
SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List
A service pack failed with: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Here is what I found.
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.
Specified Driver Is Invalid in SQL Server Setup: Error 0x84BB0001
The specified driver is invalid error stopped a SQL Server 2012 installation with code 0x84BB0001. The real clue sat in Detail.txt, in the performance counter files, and a fresh copy of the media fixed it. This post shows how to read the logs, check the counter files and confirm the media.
UpdateHADRResource Failed to Version-Copy File: System.IO.IOException
UpdateHADRResource failed during a 2017 SQL Server 2012 patch because Setup could not copy hadrres.dll while another process used it. This post shows how to read the setup log, check the file and its owner, and read the HADR state of an instance with tested queries and commands.
SQL SERVER – Error – Attempted to Perform an Unauthorized Operation
A reader’s SQL Server 2016 setup log showed ‘Attempted to perform an unauthorized operation’ during local discovery. Here is what caused it and the fix.