MySQL rejected every password with “does not satisfy the current policy requirements”. Here is how to check the validate_password settings and fix it.
Msg 3168: Backup Made by a Different SQL Server Version
Msg 3168 stopped a client from restoring master after a ransomware attack, because the backup and the new server had different build numbers. The fix is to make the two builds match, by patching up or uninstalling patches, and then restore again.
SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped
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.







