SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
8623
Error 8623: The Query Processor Ran Out of Internal Resources
Error 8623 means the query is too complex to compile, usually a huge IN list or generated SQL. Simplify or…
833
Error 833: I/O Requests Taking Longer Than 15 Seconds on Your Storage
Error 833 and 845 are early warnings that storage cannot keep up. Correlate with latch waits and scheduler errors 17883…
0xC020801C
SSIS Error 0xC020801C: Cannot Acquire Connection From Connection Manager
Error 0xC020801C means the package could not open a connection at run time. Check the protection level, stored passwords and…
0xC02020A1
SSIS Error 0xC02020A1: Data Conversion and Truncation Failures in a Data Flow
0xC02020A1 means a column value would not convert. Read the status text it carries, then fix the column width, the…
0xC0047062
SSIS Error 0xC0047062: Packages Fail as Agent Jobs but Run in Visual Studio
0xC0047062 carries a managed component's own exception. Read that exception, then line up bitness, providers and the proxy account with…
22022
Error 22022: SQLServerAgent Is Not Currently Running, or Does Not Exist
Error 22022 means Agent is stopped, or on Express absent entirely because the edition has no scheduler. Confirm which case…
17809
Error 17809: The Maximum Number of User Connections Has Been Reached
Error 17809 means the user connections setting is capped or exhausted. Raise it with sp_configure, fix pool leaks and check…
20011
Error 20011 and 20084: Replication Agent Failures and Rejected Subscriptions
Error 20011 is the outer line on a failed replication agent; the cause is the inner error in agent history.…
8645
Error 8645: Memory Grant Timeouts Against the Standard Edition Memory Cap
Error 8645 and 8657 mean queries queue for memory that never frees. On Standard the buffer pool cap is a…
18752
Error 18752: Only One Log Reader Agent Can Connect to the Database
Error 18752 means two log readers or a stale session are fighting over one published database. Clear the orphaned agent…
40544
Error 40544: The Azure SQL Database Has Reached Its Size Quota
Error 40544 and the 4055x session kills mean the service tier ran out of headroom. See which limit you hit,…
7391
Error 7391: The Linked Server Could Not Begin a Distributed Transaction
Error 7391 with 8501 means MSDTC is not talking between the two servers. Configure network DTC access, RPC settings and…