Skip to Content
0
Former Member
Jan 24, 2012 at 11:51 AM

JDBC receiver MS SQL Server encryptation

111 Views

Hi all,

I have to configure a communication channel from a PI 7.0 to MS SQL Server 2005 database to execute updates. I have already deployed the com.microsoft.sqlserver.jdbc.SQLServerDriver driver.

I have been asked whether SSL encryptation can be used. I have found an example for an Oracle database. The following aditional parameters can be specified:

driver.oracle.net.encryption_clien = ACCEPTED

driver.oracle.net.encryption_types_client = RC4_40

driver.oracle.net.crypto_checksum_client = ACCEPTED

driver.oracle.net.crypto_checksum_types_client = MD5

Does anybody know if these or similar parameters can be used for the SQL Server Driver?

Thanks in advanced for your advice