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.
SQL SERVER – Login Failed – Server is in Script Upgrade Mode – Deleting Collection Set “Utility Information”
Login failed because the server was in script upgrade mode, stuck while deleting collection set ‘Utility Information’. Here is how we got past it.
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.
SQL SERVER – Fix: The EXECUTE Permission was Denied on the Object ‘xp_cmdshell’, Database ‘mssqlsystemresource’,schema ‘sys’.
A retail team let non-sysadmin users run xp_cmdshell and got Msg 229: the EXECUTE permission was denied on the object. Here is the fix.