The driver supports SSL encryption. Depending on your Microsoft SQL Server configuration, you can choose to encrypt all data, including the login request, or encrypt the login request only. Encrypting login requests, but not data, is useful for the following scenarios:
When your application needs security, but cannot afford to pay the performance penalty for encrypting data transferred between the driver and server.
When the server is not configured for SSL, but your application still requires a minimum degree of security.
Note: When SSL is enabled, the driver communicates with database protocol packets set by the server’s default packet size. Any value set by the PacketSize property is ignored.
When your application needs security, but cannot afford to pay the performance penalty for encrypting data transferred between the driver and server.
