Solved

Application running on Sql random disconnects

Posted on 2013-10-22
8
365 Views
Last Modified: 2014-04-09
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.
0
Comment
Question by:tips54
  • 5
  • 3
8 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39590633
Is the database set to autoclose?

If so, try setting autoclose to off or false.
0
 

Author Comment

by:tips54
ID: 39590961
I will check.   SQL 2005 by the way.
If it was set to auto close wouldn't everyone get disconnected at the same time?
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39591149
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.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:tips54
ID: 39591475
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?
0
 

Author Comment

by:tips54
ID: 39595393
no suggestions?  I am about to replace this server?
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39596502
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.
0
 

Accepted Solution

by:
tips54 earned 0 total points
ID: 39762786
I ended up migrating the SQL server role to another box.
0
 

Author Closing Comment

by:tips54
ID: 39988218
ok
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question