Is This Content Helpful?
We're glad to know this article was helpful.
After updating the SQL Server client to ODBC Driver 13 for SQL Server from ODBC 11 or an earlier version of the SQL Server Native client, connections from ArcGIS 10.4.1 or ArcGIS Pro 1.3 to a SQL Server 2008 or 2008R2 instance fail with an error.
Error: Failed to connect to specified DBMS instance. (Release of Geodatabase is either invalid or out of Date)Error logs or database management system (DBMS) traces may identify an additional error:
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'
ArcGIS 10.4.1 and ArcGIS Pro 1.3 add support for the Microsoft ODBC Driver 13 for SQL Server. This driver is required for connections to SQL Server 2016. While Microsoft attempts to make all its client drivers backward compatible to older releases, it is not guaranteed for releases that are in extended support, such as SQL Server 2008 or 2008 R2.
The Microsoft ODBC Driver 13 for SQL Server has an equivalency bug and is not fully compatible with SQL Server 2008. A case has been opened with Microsoft and the issue has already been identified by other users: Attempt to use BCP 2016 to export from SQL 2008 or earlier fails with obscure error message.