Having trouble setting up a new openfire installation. I have a 2019 server with 2017 SQL installed. I created a database called OpenFire, installed the latest openfire and when I walk through the initial setup it simply wont’ connect to the database. I’ve try connecting using the SQL legacy and SQL entering in my server and database information to no avail. I’m not a SQL developer so bare with me there. There could be a user problem with the database maybe? I’m using the SA user to connect. I’ve also created a user OpenFire in SQL and tried to connect with that to no avail.
when using - com.microsoft.sqlserver.jdbc.SQLServerDriver
I use - jdbc:sqlserver://“server IP address”:1433;databaseName=OpenFire;applicationName=Openfire
I’ve also tried the legacy config and it won’t connect, error log also below
2019.09.27 14:30:51 INFO [pool-2-thread-1]: org.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool (attempt 10 out of 10).
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ‘Openfire’. ClientConnectionId:908a0150-786c-48f2-805b-bd15f06a52a7
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:258) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:104) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5036) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3668) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:94) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3627) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2456) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2103) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1950) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1162) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:735) ~[mssql-jdbc-7.2.2.jre8.jar:?]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_202]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_202]
at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) ~[commons-dbcp2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) ~[commons-dbcp2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) ~[commons-pool2-2.6.2.jar:2.6.2]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) ~[commons-pool2-2.6.2.jar:2.6.2]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) ~[commons-pool2-2.6.2.jar:2.6.2]
at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) ~[commons-dbcp2-2.6.0.jar:2.6.0]
at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnectionProvider.java:91) ~[xmppserver-4.4.2.jar:4.4.2]
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.4.2.jar:4.4.2]
at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1217) [xmppserver-4.4.2.jar:4.4.2]
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.4.2.jar:4.4.2]
at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.4.2.jar:4.4.2]
at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:395) [xmppserver-4.4.2.jar:4.4.2]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.runAndReset(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]