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 – How to Protect Your Database from Ransomware?
Protect SQL Server from ransomware with isolated backups, encryption, least privilege, tested restores, and a clear recovery sequence.
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.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Here is how the ERRORLOG led me to the cause.
SQL SERVER – Logon Failure: The User has not Been Granted the Requested Logon Type at This Computer
SQL Server will not start: the user has not been granted the requested logon type. No ERRORLOG, because Windows refused. Also error state 10013.
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
How do you change owner of a database in SQL Server? Three ways, including ALTER AUTHORIZATION, which I prefer, and the deprecated sp_changedbowner.