Author: Peter Whyte

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

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

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. 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. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 825  ·  Level 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 messages in the SQL Server error log and system…

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

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 15023  ·  Level 16  ·  State 1 User, group, or role ‘AppUser’ already exists in the current database. Msg 15023, Level 16, State 1 ⚡Do not drop the user. ALTER USER [name] WITH LOGIN = [name]; remaps it to…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 4060 / 4064  ·  Level 11  ·  State 1 Cannot open database “YourDb” requested by the login. The login failed. Login failed for user ‘DOMAIN\user’. Msg 4060, Level 11, State 1 ⚡Check three things in order: the database name…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Almost everyone meets this the first time they back up to a network share, and almost everyone spends the first ten minutes checking the wrong account. Msg 3201  ·  Level 16  ·  State 1 Cannot open backup device ‘X’. Operating…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. This one gets misread constantly, and the misreading costs real time. It looks like a login problem, people go and check the password, and the password was never the issue. The clue is in the first half of the sentence.…

Every entry here is a message somebody pasted into a search box while something was broken. This page exists to get you from that message to the cause quickly, which is a different job from explaining what SQL Server errors are in general. Three Steps From Message to Cause 01 Get the real message The…