SQL Server

SQL Server engine errors, backup and restore failures, availability groups and corruption checks.

70 articles

Error 3624 Assertion Failures: When a Cumulative Update Is the Only Fix

Error 3624 with 17065 in the log is an internal consistency check failing. Capture the dump, match the assert to…

Error 18487 means the SQL login password expired and 18488 means it must be changed. Reset it correctly and decide…

Error 15023 appears when a restored database carries users whose SIDs no longer match the server logins. Remap them with…

Error 18452 and the 17806 SSPI handshake failure both point at broken Kerberos. Check SPN registration, delegation and the service…

Error 229 means the principal is authenticated but lacks a grant. Learn where to apply permissions so you fix access…

Error 53 and error 26 mean the client never located the instance. Work through DNS, the SQL Browser service, UDP…

Error 10061 means nothing is listening on the port and 10060 means packets are being dropped. Separate the two and…

Error 233 appears when the pre-login handshake dies before authentication. Check shared memory, named pipes, TLS settings and packet error…

Error 10054 and error 64 mean an established session was cut mid-flight. Trace it to TLS mismatches, NIC offload, idle…

Error 18456 hides the real reason in its state number. Map the published states to bad passwords, disabled logins and…

← Prev 1…4 56