\uD83E\uDD14 Problem
Using HiveMQ broker version >= 4.25.0
Using Enterprise Security Extension with MS SQL realm
The database name in the MS SQL realm configuration contains
;encrypt=false
When the Enterprise Security Extension is starting, it fails to connect to the MS SQL database.
\uD83C\uDF31 Solution
Update the configuration of the MS SQL realm in the ESE config.xml file.
Remove
;encrypt=false
from the database name in the MS SQL realm configurationRestart the ESE.