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. 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.
SQL SERVER – Script to Audit Login and Role Member Change
A script to audit login and role member changes in SQL Server, tested end to end, including the failed attempts most people never think to capture.
SQL SERVER – Log Shipping Copy Job Failure – The Password for This Account Has Expired
A reader’s log shipping copy job was failing with ‘The password for this account has expired’. Here is how we found the cause and fixed it.