skip to main content
Using the Driver : Using Security : Authentication : Summary of Authentication-Related Options
  

Try DataDirect Drivers Now
Summary of Authentication-Related Options
The following table summarizes how authentication-related connection options work with the drivers. The connection options are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name is listed in parentheses. See "Connection Option Descriptions for SQL Server Wire Protocol" for details about configuring the options.
Table 5. Summary: Authentication Connection Options
Option
Description
Specifies the method the driver uses to authenticate the user to the server when a connection is established.
If set to 1 (Encrypt Password), the driver sends the user ID in clear text and an encrypted password to the server for authentication.
If set to 4 (Kerberos Authentication), the driver uses Kerberos authentication. This method supports both Windows Active Directory Kerberos and MIT Kerberos environments.
Setting this value to 4 also enables NTLMv2 and NTLMv1 authentication on Windows platforms. The protocol used for a connection is determined by the local security policy settings for the client.
(UNIX and Linux only) If set to 9 on Linux and UNIX platforms, the driver uses NTLMv1 or NTLMv2 authentication. The driver determines which protocol to use based on the size of the password provided. For passwords 14 bytes or less, the driver uses NTLMv1; otherwise, the driver uses NTLMv2. To connect to the database, users must supply the Windows User Id, Password, and, in some cases, Domain to the driver.
(UNIX and Linux only) If set to 10, the driver uses NTLMv2 authentication. To connect to the database, users must supply the Windows User Id, Password, and, in some cases, Domain to the driver.
If set to 13 (Active Directory Password), the driver uses Azure Active Directory (Azure AD) authentication when establishing a connection to an Azure SQL Database data store. All communications to the service are encrypted using SSL.
Default: 1 (Encrypt Password)
The name of the GSS client library that the driver uses to communicate with the Key Distribution Center (KDC).
Default: native (The driver uses the GSS client shipped with the operating system.)
The default user ID that is used to connect to your database.
Default: None
* Connection String Examples for Configuring Authentication
* odbc.ini File Examples for Configuring Authentication