Microsoft SQL Server can use Secure Sockets Layer (SSL) to encrypt data that is transmitted across a network between an instance of SQL Server and a client application. It is recommended that encryption be forced for all incoming connections. Encrypted connections prevent capturing sensitive data in transit. Using a certificate issued by a CA prevents man-in-the-middle attacks.