Datenbankverbindungen zu SQL Server schlagen fehl, wenn Microsoft ODBC Driver 18 installiert ist

Beschreibung

When the Microsoft ODBC driver 18 has been installed on a client machine, and when connecting to a SQL Server database using ArcGIS Pro, connection errors similar to the following may be encountered:

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[].

Ursache

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.

Problemumgehung

The following suggestions can help avoid and rectify the connection error when ODBC 18 exists on the ArcGIS client machine:

• Uninstall ODBC 18 and install ODBC 17 instead
• Install a trusted certificate
• Set Encrypt=No in the ArcGIS database connection dialog, as shown in the following image:

• Set TrustServerCertificate=Yes in the ArcGIS database connection, as shown in the next image: 

In some cases, an error similar to the following may be received after making the above changes to the instance connect string:

Connection was attempted with an older version of SQL Server client communications software that is not supported[].

This error can occur when using some versions of ArcGIS Pro with ODBC driver 18 with the addition of the Encrypt or TrustServerCertificate settings.  In these instances, you must install an older supported ODBC driver (ODBC 17, 13, etc.) alongside ODBC driver 18, as shown in the next image.

Future releases of ArcGIS will reset the default value for Encrypt back to ‘No’ to match previous ODBC Driver releases. As before, you will still be able to manage the Encryption setting as documented in the online help documentation: Encrypted connections to SQL Server databases.