ODBC Driver for SQL Server

SSL Connection

SSL (Secure Sockets Layer) is the protocol for secure access to remote computers over insecure communication channels.

The SSL protocol runs above TCP/IP and below higher-level database protocol. It uses TCP/IP on behalf of the higher-level protocols, and in the process allows an SSL-enabled server to authenticate itself to an SSL-enabled client, allows the client to authenticate itself to the server, and allows both machines to establish an encrypted connection.

These capabilities address fundamental concerns about communication over the Internet and other TCP/IP networks:

SSL is based on algorithms of asymmetric encryption and digital signature. Consult SQL Server Reference Manual for information about How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console .

Note:

Usage of SSL is more preferable for SQL Server connections than SSH because of less required settings and higher performance.

How to connect to SQL Server using SSL

To use SSL encryption for connection to SQL Server, the corresponding SSL connection options should be set:

Using ODBC Data Source Administrator

SSLConnection

Using Connection String

Login Prompt=False;User ID=sa;Data Source=DBMSSQL;Port=1433;Use SSL=true;SSL CACert=c:\cacert.pem;SSL Cert=c:\client-cert.pem;SSL Key=c:\client-key.pem;SSL CipherList=ALL

Connection Options Description

Option

Description

Use SSL

Enables or disables SSL for connection.

SSL CACert

Holds the pathname to the certificate authority file.

SSL Cert

Holds the pathname to the certificate file.

SSL CipherList

Holds the list of allowed ciphers to use for SSL encryption.

SSL Key

Holds the pathname to the key file.

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback