MS SQL Server 2014 error #08S01

3971
5
02-01-2017 10:15 AM
MatthewDowning1
New Contributor

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.

0 Kudos
5 Replies
AdamZiegler1
Esri Contributor

Hi Matthew - Do you have the Microsoft SQL Server 2012 Native Client installed on the machine you are trying to execute the writes from? If not, it can be downloaded from your My Esri portal under the ArcGIS Server or ArcGIS Enterprise sections in the additional products category.

-Adam Z

0 Kudos
MatthewDowning1
New Contributor

Yep I have that installed.

0 Kudos
AdamZiegler1
Esri Contributor

How about time out settings? What is the Remote query timeout set to? This is a property of your SQL Server instance, in the Connections page.

-Adam Z

0 Kudos
MatthewDowning1
New Contributor

Everything is the same settings as your screenshot. 600 seconds.

0 Kudos
HéctorMeléndez
Esri Contributor

Did you get to resolve this issue?

0 Kudos