AnsweredAssumed Answered

Error: Failure to access the DBMS server

Question asked by tcatkins99 on Jan 29, 2015
Latest reply on Aug 25, 2016 by tcatkins99

We seem to run across this error at seemingly random intervals on our server services. The full text of the error is:

 

Error: Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An established connection was aborted by the software in your host machine. ]

 

Reading up on Azure, it looks like Azure is closing the db connections on their own for...reasons? Anyway, is there a solution to this? So far the only thing I've found that works is either restarting the service or waiting for the server to shut down an idle instance and restart a new one. I've even tried putting a small python script on the scheduler that will hit the service with a random query every 10 or 15 minutes to no avail.

 

Specs:

Arcgis Server 10.3 Enterprise Standard (vanilla install..no extensions, no portal)

Azure A3 VM running 2012 R2 Enterprise Server (4 cores, 7 gigs ram)

Azure S2 Database (50 DTUs)

 

Our database is ~3.5 gigs with around a million records or so.

 

Thanks. The Azure platform with server is awesome otherwise.

Outcomes