Encrypted connection to a SQL server DB via JDBC

Stefano
Tera Contributor

Hello everyone,

I need to connect via JDBC and via MID server to a SQL server DB. However, the connection must be encrypted via TLS. I configured a "JDBC Connection" and the "Connection URL" is generated in the screen. However, I have not found a way to insert the "Encrypt=True" parameter that enables the connection via TLS to the DB. Can you give me some instructions? Thanks everyone.

 

Stefano_0-1729675904525.png

 

1 REPLY 1

Jeff Currier
ServiceNow Employee
ServiceNow Employee

I believe you have two options here.  You can require the TLS version on the SQL Server side, thus all connections would need to meet that minimum.  Or you can set the Java version on your Mid Server.  Java version 1.8+ uses TLS 1.2 by default, thus your connection will be encrypted by default.

I was unable to confirm this, but I believe all currently supported versions on the ServiceNow JDBC connection require SSL or encrypted communication, so I don't think unencrypted is an option which sounds like that would be OK with you.