SQLServerException: "Unable to verify FIPS mode settings"

News Knowledge Base
, , ,
1

AI Center application throwing com.microsoft.sqlserver.jdbc.SQLServerException: "Unable to verify FIPS mode settings."

Issue Description:
AI Center application is throwing com.microsoft.sqlserver.jdbc.SQLServerException: "Unable to verify FIPS mode settings."


Root Cause:
This is error is thrown by the JDBC driver when the SQL connection string is not considered valid for FIPS. It is a client side error.


Diagnosing:

  1. Check the connection string and make sure it matches the documentation: Requirements for AI Center installed on a FIPS 140-2-enabled machine
    1. Make sure Encrypt is True and TrustServerCertificate is false.
  2. See the Microsoft documentation: Appropriate configuration parameters
    1. Some the required parameters, Automation Suite will append when passed to the application.
  3. To see the actual connection string used by the application at run time, run the following command: 
    • kubectl -n uipath get secret aicenter-secrets -o jsonpath='{.data.sqlConnectionString}' | base64 --decode
  4. If the issue is not clear, raise a ticket. Include the Support Bundle and the output of the secret command (Removing any passwords).