Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.
Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved
SQL Server would not start under a domain account when a Read Only Domain Controller (RODC) was involved. Here is what fixed it.
SQL SERVER – How to Enable Lock Pages in Memory?
Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
SQL SERVER – Msg 15137, Level 16 – Error Related to sp_xp_cmdshell_proxy_account
A client using a proxy account to run xp_cmdshell hit Msg 15137 with sp_xp_cmdshell_proxy_account. Here is what causes the error and how I fixed it.
SQL SERVER – xp_logininfo – Msg 15404: Could not obtain information about Windows NT group/user, error code 0x2147
xp_logininfo failed with Msg 15404 for some users, yet worked for the same user in another domain. Here is what to check to find the difference.
Script Upgrade Mode in SQL Server: Login Failed (Error 18401) While Deleting a Collection Set
Script upgrade mode can reject logins for a while after a SQL Server update, and in this 2017 client case the startup log stopped at a collection set cleanup. This post shows how to read error 18401, check whether the upgrade still moves and size the msdb logging tables with tested queries.
SQL SERVER – Ransomware Protection and Recoverable Offline Backups
Ransomware recovery depends on protected backups and controlled access. I test whether those recovery copies survive the loss of normal systems.