AnsweredAssumed Answered

MS SQL Server 2014 error #08S01

Question asked by mdowning_DCP on Feb 1, 2017
Latest reply on Dec 10, 2018 by hrmeagle-co-nz-esridist

After upgrading our database from SQL Server 2008 to 2014 I am experiencing issues when overwriting some of our larger datasets. After some amount of time the overwriting process abruptly terminates. The error seems to be coming from the SQL side and reads: "Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available.]"


This happens both when using python or the Arc tools user interface to perform either the Append or FeatureClassToFeatureClass tools. I've also tried running these tasks on off hours when the server is under minimal load to no avail. There were no issues when we were on SQL Server 2008 and the python scripts are the exact same as before the upgrade.


I have the SQL Server Native Client 2012 installed and the Remote Query Timeout setting is at 600 seconds. Our ArcGIS client is 10.3


Has anyone experienced and resolved this issue before? I'm sure I left out some pertinent details which I can add.