Using SSL Encryption
Secure Sockets Layer (SSL) encryption enables transmitting encrypted data across the network between an instance of SQL Server and a client application.
Secure Sockets Layer (SSL) is a protocol for establishing a secure communication channel to prevent the interception of critical or sensitive information across the network and other Internet communications. SSL allows the client and the server to authenticate the identity of each other. After the participants are authenticated, SSL provides encrypted connections between them for secure message transmission.
The Microsoft JDBC Driver for SQL Server provides an infrastructure to enable and disable the encryption on a particular connection based on the user specified connection properties and the server and client settings. The user can specify the certificate store location and password, a host name to be used to validate the certificate, and when to encrypt the communication channel.
Enabling SSL encryption increases the security of data transmitted across networks between instances of SQL Server and applications. However, enabling encryption does slow performance.
The topics in this section describe how the Microsoft JDBC Driver for SQL Server version supports SSL encryption, including new connection properties, and how you can configure the trust store at the client-side.
The hostNameInCertificate connection property is recommended to validate an SSL certificate.
Describes how the Microsoft JDBC Driver for SQL Server supports SSL encryption.
Describes how to connect to a SQL Server database by using the new SSL specific connection properties.
Describes how to configure the default trust store at the client-side and how to import a private certificate to the client computer's trust store.