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.
Valid Values
1 | 4 | 9
Behavior
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.
Note: Microsoft Windows Azure SQL Database supports only SQL Server authentication. You must provide credentials every time when you connect to SQL Database.
Setting this value to 4 also enables NTLM authentication on Windows platforms.
If set to 9 on Linux and UNIX platforms, the driver uses NTLM authentication. To connect to the database, users must supply the Windows User Id, Password, and, in some cases, Domain to the driver. Note that NTLM single sign on is supported only on Windows.
