powered by Jive Software

Openfire connecting to SQL Server which requires TLS 1.2 - doesn't work

We use SQL Server as Openfire 4.3.2 database. It was working. Recently there was a requirement to enforce TLS 1.2 on SQL Server. It broke Openfire connection to SQL Server. Even admin UI doesn’t work. I tried to modify string by adding “ssl=require;” as https://stackoverflow.com/a/14512206/236391 and https://www.netiq.com/communities/cool-solutions/enforcing-ssl-tlsv1-2-jdbc-connection-via-jtds-jdbc-driver/ suggest - it didn’t help. Any ideas?

All.log shows errors like
"org.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool … java.sql.SQLException: Network error IOException: Connection reset "

Hi @vkelman, how did you solve this? I use an old version of Openfire v4.1.1 and have to use it. I am trying to the same but I could not achieve. Thanks