Configuring Authentication

Connections to SQL Server require authentication. You can authenticate the connection using your SQL Server user account, the Kerberos protocol, or the NTLM protocol.

Using a User Account

You can authenticate the connection by providing your user name and password for accessing the SQL Server instance.

To configure authentication using a user account:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
  2. In the User and Password fields, type your credentials for accessing the server.

Using Kerberos

You can authenticate the connection by using the Kerberos protocol.

To configure authentication using Kerberos:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
  2. Select the Use Trusted Connection check box.
  3. Optionally, in the Server SPN field, type the service principal name of your SQL Server instance.
    Note: If you leave the field empty, then the connector uses MSSQLSvc/[HostName]:[Port] as the service principal name, where [HostName] is the IP address or host name of the server and [Port] is the number of the port that you are connecting to.

Using NTLM

You can authenticate the connection by using the NTLM protocol.

To configure authentication using NTLM:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
  2. Select the Use NTLM check box.
    Important: Make sure that you clear the Use Trusted Connection check box. If Use Trusted Connection is selected, then the Use NTLM option is not available and the connector uses Kerberos authentication instead.
  3. In the User and Password fields, type your credentials for accessing the server.