SQL Server 2019 Openfire 4.6.2

Openfire
1

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

2

Hi @phmo16, did you able to make it work with SQL Server 2019?

3

What problem are you facing with SQL Server 2019?

I’ve got a containerised version working locally.
The connection string looked like this: https://github.com/Fishbowler/openfire-docker-compose/blob/b6483b24b7ba420c929d4c1d21d14d6a5fadee1a/sqlserver/xmpp/conf/openfire.xml#L46-L47