Application running on Sql random disconnects
Posted on 2013-10-22
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.
Microsoft OLE DB Provider for SQL Server.
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.