dof81

Direct connection to SQL Server (Azure) from Geoprocessing Service 10.1

Discussion created by dof81 on May 14, 2013
Hello,
I have a geoprocessing service 10.1 that connects to SQL Azure DB in order to append some data in direct connection.

Everything works fine, so from my Web Interface I can call my geoprocessor and display the results.
Sometimes (random) ArcGIS Server loses connection to the DB but I don't understand why.
The error is:

Error executing tool.: ERROR 999999: Error executing function. Failure to access the DBMS server[[Microsoft][SQL Server Native Client 10.0]Communication link failure] Failure to access the DBMS server[08S01:[Microsoft][SQL Server Native Client 10.0]TCP Provider: An established connection was aborted by the software in your host machine. ] Failed to execute (Append). Failed to execute (DataReporting2). Failed to execute (DataReporting_Model)

I think the problem is related to ArcGIS Server because I have notice similar behavior also for other SQL Server DB connections, not only in the cloud.
How does ArcGis Server direct DB connection work? Is there any known bug? it seems that some connections remain opened and may be the DB closes idle connections after some minutes....

Any help please?
Thank you
Fabio

Outcomes