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.
Operating System Error 1326 in SQL Server: Cannot Open Backup Device
Operating system error 1326 means authentication failed while SQL Server tried to open its backup destination. In this 2017 case SQL Server ran on a workgroup computer and the share sat on a domain server. The tests here compare error 1326 with the path errors 3 and 67 and show how to read the service identity.
SQL SERVER – FIX – Error 1402. Could not open key: UNKNOWN\Components. System error 5
Installing a SQL Server service pack failed with Error 1402. Could not open key: UNKNOWN\Components. System error 5. Here is the fix.
Database Mirroring Connection Error 4: An Error Occurred While Receiving Data 10054
A database mirroring connection error needs evidence from both ends of the connection. In a 2017 Azure case, the clue was a missing CONNECT permission on the endpoint. I tested the endpoint queries on SQL Server 2025 with a scratch endpoint, a grant, a deny and a stopped endpoint.