Security and Authentication

To protect data from unauthorized access, SQL Server data stores require connections to be authenticated with user credentials and sometimes the TLS protocol. The Simba SQL Server ODBC Driver provides full support for these authentication protocols.

The connector provides mechanisms that enable you to authenticate your connection using the Kerberos protocol, the NTLM protocol, or your SQL Server user name and password. For detailed configuration instructions, see Configuring AuthenticationConfiguring Authentication.

Additionally, the connector supports TLS connections with or without one-way authentication. If the server has a TLS-enabled socket, then you can configure the connector to connect to it. The connector supports TLS 1.0 to 1.2. The TLS version used for the connection is the highest version that is supported by both the connector and the server.

It is recommended that you enable TLS whenever you connect to a server that is configured to support it. TLS encryption protects data and credentials when they are transferred over the network, and provides stronger security than authentication alone. For detailed configuration instructions, see Creating a Data Source NameConfiguring TLS Verification.