Skip to Content
Technical Articles
Author's profile photo Yang Yang

FIM doesn’t work with MS SQL Server 2019

Recently a couple of cases were reported about this topic.

No changes from the application side, just upgrading the database from MS SQL Server 2016 to 2019, then when you check the database configuration on FIM Admin, there shows an error like the following:

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “SQL Server did not return a response. The connection has been closed.”

We already have some KBAs for the error message, the root cause is that the default sqljdbc4.jar does not well support MS SQL Server 2019.

To resolve the issue permanently, you can take the following actions:

  • Check your java version for your FIM application server by running “java -version” in a command window, for example in my case I am using Jave 1.8

JAVE%20Version

  • Then go to the following MS documentation page, and click “see previous Microsoft JDBC Driver for SQL Server releases” to find the proper JDBC driver. In my case, I need the JDBC 4.2 which supports JDK 8.

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

  • Download the file and unzip it.
  • Go to %Tomcat%\webapps\fim\lib, rename the sqljdbc4.jar to sqljdbc4.jar.bk.
  • Copy the sqljdbc42.jar to the folder.
  • Restart Tomcat.

Then you will be able to pass the check.

 

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.