powered by Jive Software

SQL Server 2019 Openfire 4.6.2

openfire_4_6_2_bundledJRE_x64

Hi Please can anyone help

SQL server 2019 - tested all compatibility options
Windows 2019 Server
options
tested legacy driver

Local sql server with TCP port 1433 and only openfire db
unable to connect to the database.
java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Login failed for use sql01\adminuser

same error with local user sql login and domain windows user

I can connect and administer the DB openfire logged on with either the sql user or windows domain user.
Any tips?

rg.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool