Fixed setting of SQL_ATTR_PARAMS_PROCESSED_PTR under specific conditions.Fixed character encoding of VARIANT columns in BCP NATIVE mode.Support for inserting into encrypted money and smallmoney columns.Support Azure Active Directory Service Principal authentication.Support Azure Active Directory Interactive authentication (Windows-only) against Azure Key Vault when using Always Encrypted.Version 17.7.1 brings several new features and fixes to the driver.
Version 17.7 of the Microsoft ODBC Driver 17 for SQL Server has been released. See the original author and article here.
Azure Active Directory - Password-You must provide a valid Azure Active Directory username and password in the User name and Password text boxes, respectively.This article is contributed.This second part of the authentication process varies depending on how your network and authentication protocols are configured.
When you connect, a code is sent to you in a text message, email, or MFA device, or it can use aįingerprint scan for authentication.
If you do not have the privileges to install software on the machines where ArcGIS clients are running, you'll need to have your IT department install and configure the Microsoft ODBC driver for you.įor example, if you are using a default SQL Server instance, you can specify the instance name or the IP address of the server in the Instance text box.
Install the driver on all computers where ArcGIS Pro and ArcGIS Server are installed. Be sure to get the Microsoft ODBC driver that is supported for the version of SQL Server to which you want to connect. Obtain the 64-bit Microsoft ODBC driver for SQL Server from the Microsoft Download Center or from My Esri. If you are not the database administrator, contact the database administrator if you receive errors when connecting that indicate the instance is not accepting connections.Īdditional configuration is required on the SQL Server and client machine to use encrypted connections. See the Microsoft SQL Server documentation for more information. If you have a new installation of SQL Server, ensure the SQL Server service is running and listening on the correct ports.
Install a Microsoft ODBC driver on the ArcGIS client machines.