Problem: After upgrading to ArcGIS 10.4 for Server, existing services that use data in geodatabases in SQL Server no longer work
After upgrading ArcGIS for Server to version 10.4, services that consume data in geodatabases in SQL Server 2008 or 2008 R2 no longer function.
ArcGIS Server logs show messages indicating "Connection was attempted with an older version of SQL Server client communications software that is not supported."
Beginning with ArcGIS 10.4, SQL Server 2008 and 2008 R2 are no longer supported.
Solution or Workaround
Upgrade to SQL Server 2012 or SQL Server 2014, which are supported at ArcGIS 10.4
Customers who must continue to have access to their SQL Server 2008 or 2008 R2 geodatabases while planning their upgrade to SQL Server 2012 or SQL Server 2014, can upgrade the SQL Server client on the ArcGIS for Server machine to SQL Server 2012 Native Client or Microsoft ODBC Driver 11, and restart the ArcGIS Server Windows service.
If a customer has moved to ArcGIS 10.4, but has connections to older geodatabases in SQL Server 2008 and 2008 R2, Esri Support will attempt to reproduce the issue with SQL Server 2012 or SQL Server 2014. If the issue cannot be reproduced on a supported version of SQL Server, the customer will be asked to update their version of SQL Server. Also, customers who move to ArcGIS 10.4 but are still using SQL Server 2008 or 2008 R2 will not be able to create a new geodatabase until they upgrade SQL Server to a supported release.
- Microsoft SQL Server database requirements for ArcGIS 10.4
- Connect to Microsoft SQL Server from ArcGIS
- Manage connections in SQL Server
Last Published: 6/2/2016
Article ID: 000013243
Software: ArcGIS GeoEvent Server 10.4.1, 10.4 ArcGIS Server 10.4.1, 10.4 ArcGIS Image Server 10.4.1, 10.4