ODBC Driver for SQL Azure

SSL Connection Description

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 Azure Reference Manual for information about how to Configure SSL for an application in Azure and generate certificates .

Note:

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

How to connect to SQL Azure using SSL

To use SSL encryption for connection to SQL Azure, enable the Use Encryption for Data option.

Using ODBC Data Source Administrator

SSLConnection

SSL Options Description

Option

Description

Use Encryption for Data

Enables or disables data encryption using SSL.

Example Connection String

Server=TCP:azureserver.database.windows.net;Port=1433;Database=myDataBase;Encryption=true;

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