laptop and a wrench

Bug

Certification of Microsoft ODBC Driver 18 for SQL Server connections.

Last Published: August 25, 2022 No Product Found
Bug ID Number BUG-000147765
SubmittedMarch 21, 2022
Last ModifiedMarch 25, 2024
Applies toNo Product Found
Version foundN/A
Operating SystemN/A
Operating System VersionN/A
Version Fixed2.8.7
StatusFixed

Description

When the Microsoft ODBC driver 18 has been installed on a client machine, the following connection errors is encountered when connecting to a SQL Server database from an ArcGIS client.

Connection error
Failed to connect to the specified DBMS instance. 
A database connection exception has occurred. 
Failure to access the DBMS server[].

Or,

Connection error
Unable to get database list.
A database connection exception has occurred. Unable to connect to database server to retrieve database list; please verify your server name, user name, and password info and try again.
Failure to access the DBMS server[].

example connection error

example connection error

Cause

Microsoft ODBC Driver 18 for SQL Server includes changes related to encrypted connections that can affect Database Connection behavior in ArcGIS.

These changes include:

  • A change to the default value of the `Encrypt` connection option from ’No’ to ‘Yes’.
  • The TrustServerCertificate is not tied to the client-side Encrypt setting.

Workaround

This bug has been addressed in the following patches and releases:

  • ArcGIS Pro 2.6.10
  • ArcGIS Pro 2.7.7
  • ArcGIS Pro 2.8.7
  • ArcGIS Pro 2.9.4
  • ArcGIS Pro 3.0
  • ArcGIS Server 10.8.1 Utility Network Patch 7
  • ArcGIS Server 10.9.1 Utility Network and Data Management Patch 2

Steps to Reproduce

Bug ID: BUG-000147765

Software:

  • No Product Found

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic