Provisioning computer object failed with error 5 is a cause of Always On listener creation failure. The cluster log showed the cluster computer object being denied access while changing the listener’s password. Giving the CNO Full Control over the listener object fixes it.
SqlServerWriter Missing in vssadmin: Causes and Fixes
SqlServerWriter missing from the vssadmin output means a backup tool that relies on VSS cannot back up SQL Server. This post checks the three causes: a space at the end of a database name, a login without sysadmin rights, and a stopped writer service. It tests the name check with a demo database.
Agent Service Missing in Configuration Manager: The Fix
An Agent service missing in Configuration Manager can come from a wrong program path. This post compares the service lists, reads the Agent path with T-SQL, checks that the file exists, and explains how to repair the path.
SQL Agent Error 7000: The System Cannot Find the File Specified
SQL Agent error 7000 (event ID 7000) stopped the SQL Server Agent service from starting after an operating system restart. The service’s path to its executable pointed to the wrong drive. Correcting the ImagePath value in the registry let the service start.
Error 15141: Upgrade Fails Because a Login Owns an Availability Group
Error 15141 means the server principal owns one or more availability groups and cannot be dropped. The msdb110_upgrade.sql script failed on a DROP LOGIN, and the script level upgrade for master failed with it. Changing the group owner to sa let the upgrade finish.
Msg 8152 Still Showing in SQL Server 2019: Check Compatibility Level
Msg 8152 still appears in SQL Server 2019 when the database runs at compatibility level 140. At level 150 you get Msg 2628, which names the column. The setting VERBOSE_TRUNCATION_WARNINGS also controls it.
Setup Error 1603: Patch Fails With Not Enough Disk Space on the Volume
Setup error 1603 appeared for three features in a SQL Server patch, all pointing to one component log. That log said Disk full: there is not enough disk space on the volume D. Freeing space on the drive was the corrective action.