Attribute

AuthenticationMethod (AM)

Purpose

Specifies the method the driver uses to authenticate the user to the server when a connection is established. If the specified authentication method is not supported by the database server, the connection fails and the driver generates an error.

Important: When Kerberos is enabled, if the database user name differs from the domain user name, you are required to pass the database user name via the User Name (LogonID) option in the datasource or connection string.

Valid Values

0 | 4

Behavior

If set to 0 (User ID/Password), the driver uses user ID/password authentication. The driver supports the SCRAM-SHA-256 hashing mechanism. During connection, the driver determines whether to send the password in hashed form or clear text based on the server settings.

If set to 4 (Kerberos Authentication), the driver uses Kerberos authentication. This method supports both Windows Active Directory Kerberos and MIT Kerberos environments.

Default

0 (User ID/Password)

GUI Tab

Security tab

See Also

Authentication