Link to home
Start Free TrialLog in
Avatar of tips54
tips54

asked on

Application running on Sql random disconnects

Good morning,

I am running into this issue that is insanely driving me up a wall.  We run this ERP application (Epicor Prophet 21 )  that connect to sql on the back end.  As of last week  a few users started experiencing random disconnect errors from the application.  now it is happening to everyone at different times.

SQLSTATE= 08s01
Microsoft OLE DB Provider for SQL Server.
Connection failure


The server hosting sql is running on VMware ESxi3.5.  I have taken several steps:
 replaced the Nic card -  I moved the server to a dedicated nic -  Moved the server to a different switch
and we are still seeing the same problem what  could the cause be?
Server: Power Edge 2950 - Intel Xeon E5420 @2.50GHz, 24Gigs of RamSelect Error:  
no errors in windows logs or Sql logs.
Avatar of Lee
Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

Is the database set to autoclose?

If so, try setting autoclose to off or false.
Avatar of tips54
tips54

ASKER

I will check.   SQL 2005 by the way.
If it was set to auto close wouldn't everyone get disconnected at the same time?
No. Autoclose closes the connection after each query. I've had issues in the past with it being enabled. It lead to random disconnections and more strangely it didn't affect my customer for months and then suddenly it was a problem.
Avatar of tips54

ASKER

ok. This issue just started a couple of weeks ago. The server has been up since 2008. Where do I found this feature in SQL?
Avatar of tips54

ASKER

no suggestions?  I am about to replace this server?
Load SQL Management Studio
Expand the server tree on the left until you see your database
Right mouse click on your database and choose Properties
On the left in the pop up choose Options
First option = Auto Close

If it is set to true, highlight it, change the option in the drop down to false.
Press OK.
ASKER CERTIFIED SOLUTION
Avatar of tips54
tips54

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tips54

ASKER

ok