skip to main content
Using the Driver : Using Security : SSL Encryption : Summary of Data Encryption Related Options : Connection String Examples for Configuring Data Encryption
  

Try DataDirect Drivers Now
Connection String Examples for Configuring Data Encryption
The following connection strings configure the SQL Server Wire Protocol driver to use data encryption via the SSL server authentication and SSL client authentication methods. These examples contain the connection options necessary to configure data encryption as well as the minimum options required to establish a connection.

SSL Server Authentication

This connection string configures the driver to use the SSL Server Authentication method. In this configuration, since ValidateServerCertificate=1, the driver validates the certificate sent by the server and the host name specified by the HostNameInCertificate option.
DSN=AcctSQLServer;EncryptionMethod=1;HostName=YourServer;
HostNameInCertificate=MySubjectAltName;PortNumber=1433;
Truststore=TrustStoreName;TruststorePassword=TSXYZZY;
ValidateServerCertificate=1

SSL Client Authentication

This connection string configures the driver to use the SSL Server Authentication method. In this configuration, since ValidateServerCertificate=1, the driver validates the certificate sent by the server and the host name specified by HostNameInCertificate.
DSN=AcctSQLServer;EncryptionMethod=1;HostName=YourServer;
HostNameInCertificate=MySubjectAltName;PortNumber=1433;
Keystore=KeyStoreName;KeystorePassword=YourKSPassword;
ValidateServerCertificate=1