Solved

Application running on Sql random disconnects

Posted on 2013-10-22
8
343 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
 

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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dynamics crm 2011 8 44
Extract XML Data from using TSQL 5 31
C# Application Local DB Connection String 23 58
Sql query for filter 12 22
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now