After a client changed the SQL Server certificate, the service would not start: Error 26014, unable to load User Specified Certificate. Here is how we fixed it.
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.
SQL SERVER – Msg 3047, Level 16, State 1: The BackupDirectory Registry Key is Not Configured Correctly
A backup without a full path suddenly failed with Msg 3047: the BackupDirectory registry key is not configured correctly. Here is why and how I fixed it.
SQL SERVER – Error: Property BackupDirectory is Not Available for Settings
Opening Restore in SSMS gave ‘Property BackupDirectory is not available for Settings’. I used a Profiler trace to find where it comes from and fixed it.
SQL SERVER – Unable to Start Services After Patching (sqlagent_msdb_upgrade.sql)
Unable to start services after patching? The ERRORLOG pointed to sqlagent_msdb_upgrade.sql failing. Here is what caused it for my client and the fix.
SQL SERVER – Fix: The Cluster Resource Could not be Deleted Since it is a Core Resource
After changing a file share witness, a client could not delete the old one: the cluster resource could not be deleted since it is a core resource. The fix.
SQL SERVER – Fix Error Msg 35336 Working with ColumnStore Indexes
A bank moving from SQL Server 2012 to 2016 wanted to use non-clustered ColumnStore indexes. Here is the error Msg 35336 we hit and how to fix it.