Category: Troubleshooting

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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 these are…

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

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. The errorMsg 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…

🚨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. The errorMsg 3201  ·  Level 16  ·  State 1 Cannot open backup device ‘X’.…