Category Archives: Bug

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading

Posted in Bug, Error Log, Limitation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

Denali — Day 1: Tempdb Compatibility – Bug?

Denali — Day 1: Tempdb Compatibility – Bug?   I have installed sql server 2012 express and evolution edition on my personal laptop, and observed that the compatibility of databases is 110 (11) for Denali. And till now when you … Continue reading

Posted in Bug, Denali, TempDB, Whats New | Tagged , | Leave a comment

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets fails with the following error Message: Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit  … Continue reading

Posted in Bug, Limitation | Tagged , , | Leave a comment

Day 30: More Fatal Errors and BUGs

Day 30 More Fatal Errors and BUGs For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record  structure(for sql server 2005 onwards you may get 824). Msg 5242, Level 22, State 1, Line 1 … Continue reading

Posted in Bug, Troubleshooting | Tagged , | Leave a comment

Day 4: Service Broker Disabled for MSDB

Description:- SNTP related jobs which sends notification failed email failing with following error: Message Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery. [SQLSTATE 42000] (Error 14650).  The … Continue reading

Posted in Bug, Troubleshooting | Tagged , | Leave a comment

Maintenance Plan "No description found" error

for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description found” and you cannot edit the Maitainance plan. problem could be the software you install is confilicting with sql server … Continue reading

Posted in Bug, General, Installation, What I learned today | Tagged , | Leave a comment