SQL Server Assertion Error While Starting SQL 2008 Service

[dFrank]

Here is an error message that I experienced on W2K8 R2 Server (Microsoft Windows [Version 6.1.7601]), on SQL 2008 Server Express (10.50.1600.1).

I was trying to start SQL Server Instance service (the main service), and here the Even Viewer message that I would get:

SQL Server Assertion: File: <sosexcept.cpp>, line=2480 Failed<br />
Assertion = 'FALSE'.   This error may be timing-related.<br />
If the error persists after rerunning the statement,<br />
use DBCC CHECKDB to check the database for structural integrity,<br />
or restart the server to ensure in-memory data structures<br />
are not corrupted.<br />
<br />
Additional details – Event ID 17066

The solution was to wait for a couple of days, run Windows update and restart a couple of times. This message is now gone and problem repaired itself.

[Author]

Posts