Author: Peter Whyte

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Server & Configuration The client could not find a SQL Server at the name you typed. Nothing reached the instance, so no login was checked and its error log has nothing to show. Check the name first, then the port,…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Security Windows authentication reached SQL Server and Windows refused the account before any login was checked. The error log gets 17806, the client usually gets 18452, and no SQL Server setting will fix it. Error 17806  ·  Severity 20  · …

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Performance & Troubleshooting Msg 2627 / 2601  ·  Level 14  ·  State 1 Violation of PRIMARY KEY constraint ‘PK_ErrDemoPk’. Cannot insert duplicate key in object ‘dbo.ErrDemoPk’. The duplicate key value is (1). Msg 2627, Level 14, State 1 ⚡Half of…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Security Msg 916  ·  Level 14  ·  State 2 The server principal “ErrDemo916” is not able to access the database “DemoDatabase” under the current security context. ⚡Check the database, not the login: the named database has no user mapped to…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Security Msg 18470  ·  Level 14  ·  State 1 Login failed for user ‘ErrDemoDisabled’. Reason: The account is disabled. ⚡Enable is one line; the real question is why it was off. sys.server_principals modify_date tells you when it changed, and the…

SQL Server error 515 names a NULL you may never have written. Leaving a NOT NULL column out of the insert produces the same message, and a default fixes that case but not an explicit NULL.

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Security Msg 18452  ·  Level 14  ·  State 1 Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. ⚡Start at the client, not the domain: whoami shows whether it is even a domain…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Storage & Capacity Msg 1105  ·  Level 17  ·  State 2 Could not allocate space for object ‘dbo.Orders’.’PK_Orders’ in database ‘YourDb’ because the ‘PRIMARY’ filegroup is full due to lack of storage space or database files reaching the maximum allowed…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Backup & Recovery Msg 825  ·  Level 10  ·  State 2 Error: 825, Severity: 10, State: 2. A read of the file ‘D:\Data\YourDb.mdf’ at offset 0x00000c46e58000 succeeded after failing 1 time(s) with error: incorrect checksum (expected: 0x2f8a1b3c; actual: 0x9d4e7a11). Additional…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Blocking & Locking Msg 1222  ·  Level 16  ·  State 51 Lock request time out period exceeded. ⚡Find the blocker, not the victim: sys.dm_exec_requests shows who holds the lock, and the classic culprit is a session sleeping with an open…