February 15, 2010 at 6:36 am
Hi,
We have SQL server 2008 and using clustering environment with 2 nodes. One .net application connects to this server. But sometimes we get the below error from the application log.
System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider error: 0 - The semaphore timeout period has expired.)"
I have checked the windows and system event logs and sql server error logs, but I didnt find any logs during that time.
Do you have any idea how to check and troubleshoot this issue.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
February 16, 2010 at 2:20 am
I can't help directly but I get the semaphore error messages when copying files across a vpn when there are connectivity issues with the connection. I think it's to do with packet acknowledgements - checkout the sql protocols blog at ms - they may have something of use
http://blogs.msdn.com/sql_protocols/
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply