Click here to Skip to main content
15,881,172 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi Friends.,

We are facing the following problem continuously since last week.

We have services, which pull data from other databases(SQL Server 2008 R2 and SQL Server 2000) to Our SQL Server Database (
XML
SQL Server 2008 R2(RTM)). This services are running more than 1 year without any problem. 

But, Since last week,

SQL Server doesn't respond properly. We are not able to login SQL Server and getting the following error:

<b>Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)</b>

We can able to login after restart the server.

Since we have checked the event viewer, we found that the following error were continuously logged.

SQL Server Assertion: File: <qxcntxt.cpp>, line=956 Failed Assertion = '!"No exceptions should be raised by this code"'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

The application which uses the SQL Server has a log file which shows the following error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.)

What is the wrong with SQL Server???</qxcntxt.cpp>
Posted
Comments
anup.bhunia 26-Sep-14 6:15am    
Though i am no expert in this area, server configuration.
Is it might be because of one server clock is not running properly, because of what SSL hand shaking might fail.
willington.d 26-Sep-14 7:14am    
How to check this in Server Configuration???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900