MS SQL connection fails for the ESE

 Problem

1. Using HiveMQ broker version >= 4.25.0

2. Using Enterprise Security Extension with MS SQL realm

3. The database name in the MS SQL realm configuration contains;encrypt=false

4. When the Enterprise Security Extension is starting, it fails to connect to the MS SQL database.

 Solution

1. Update the configuration of the MS SQL realm in the ESE config.xml file.

2. Remove;encrypt=false from the database name in the MS SQL realm configuration

3. Restart the ESE.

 Related articles