topic Re: MS SQL Server 2014 error #08S01 in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782297#M1625 <HTML><HEAD></HEAD><BODY><P>Did you get&nbsp;to resolve this issue?</P></BODY></HTML> Mon, 10 Dec 2018 23:31:55 GMT HéctorMeléndez 2018-12-10T23:31:55Z MS SQL Server 2014 error #08S01 https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782292#M1620 <HTML><HEAD></HEAD><BODY><P>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: <EM>"Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available.]"</EM></P><P></P><P>This happens both when using python or the Arc tools user interface to perform either the Append or&nbsp;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.</P><P></P><P><SPAN style="color: #242729; background-color: rgba(248, 248, 248, 0.6);">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</SPAN></P><P></P><P>Has anyone experienced and resolved this issue before? I'm sure I left out some pertinent details which I can add.</P></BODY></HTML> Wed, 01 Feb 2017 18:15:04 GMT https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782292#M1620 MatthewDowning1 2017-02-01T18:15:04Z Re: MS SQL Server 2014 error #08S01 https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782293#M1621 <HTML><HEAD></HEAD><BODY><P>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.</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/313200_pastedImage_1.png" /></P><P><IMG class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/313201_pastedImage_2.png" /></P><P></P><P>-Adam Z</P></BODY></HTML> Wed, 01 Feb 2017 18:48:40 GMT https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782293#M1621 AdamZiegler1 2017-02-01T18:48:40Z Re: MS SQL Server 2014 error #08S01 https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782294#M1622 <HTML><HEAD></HEAD><BODY><P>Yep I have that installed.</P></BODY></HTML> Wed, 01 Feb 2017 20:30:37 GMT https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782294#M1622 MatthewDowning1 2017-02-01T20:30:37Z Re: MS SQL Server 2014 error #08S01 https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782295#M1623 <HTML><HEAD></HEAD><BODY><P>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.</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/313309_pastedImage_2.png" /></P><P>-Adam Z</P></BODY></HTML> Wed, 01 Feb 2017 21:13:53 GMT https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782295#M1623 AdamZiegler1 2017-02-01T21:13:53Z Re: MS SQL Server 2014 error #08S01 https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782296#M1624 <HTML><HEAD></HEAD><BODY><P>Everything is the same settings as your screenshot. 600 seconds.</P></BODY></HTML> Wed, 01 Feb 2017 21:53:09 GMT https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782296#M1624 MatthewDowning1 2017-02-01T21:53:09Z Re: MS SQL Server 2014 error #08S01 https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782297#M1625 <HTML><HEAD></HEAD><BODY><P>Did you get&nbsp;to resolve this issue?</P></BODY></HTML> Mon, 10 Dec 2018 23:31:55 GMT https://community.esri.com/t5/geodatabase-questions/ms-sql-server-2014-error-08s01/m-p/782297#M1625 HéctorMeléndez 2018-12-10T23:31:55Z