July 11, 2008 at 9:06 am
My users are getting disconnected from SQL 2005 3 to four time for the day. The messages that they receive are
“The error message it Timeout Expired. The Timeout period elapsed prior to completion of the operation or the server is not responding
[DBNETLIB]ConnectionOpen(Connect()).SQL Server does not exist or access denied.
Any help will be much appreciated.
July 11, 2008 at 9:11 am
What is the app written in which is returning the error? Have you looked into the code that they are running when this happens? Sounds like there is some poorly written code that is either extremely slow or that is causing serious blocking issues.
Have you checked the SQL Server error log and the event log to see if there are SQL errors, restarts, or server reboots happening?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 11, 2008 at 9:27 am
Application is written in VB.
no restart or reboots.
July 11, 2008 at 9:40 am
Okay, so what is the SQL that is being run in the VB app when it times out?? How long does it take to run in SSMS/QA? What is the Query Plan for the SQL?
Do the timeouts/disconnects occur at the same time(s) every day? If, so run Profiler at that time to see what is happening on the server and then evaluate the SQL?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 11, 2008 at 10:59 am
I would check with the developer of the application. Make sure he or she has the connection and the command timeouts set correctly.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply