After fighting for a few days with connectivity issues with the “built-in” database and client connectivity, I decided to rebuild my OpenFire server (which I do love). This go-around, I will definately use SQL. So I downloaded the latest edition of Microsoft SQL Server Express, version 2017. I installed it, then installed OpenFire, and then I could never get it to connect/authenticate. The log file indicated that it was a login/authentication/password issue. I tried everything but it would never connect. I could not find anything that said 2017 wasn’t compatible so I thought I would write this post. Firewalls all turned off, nothing blocking, can telnet to the SQL server on the right port… just no luck getting Openfire to connect (during the post-install, setup wizard phase). So I uninstalled all of the 2017 SQL pieces and started over with SQL 2014 Express. After Completing the install, creating the database, running the SQL script (again, now on 2014) for OpenFire, I was able to connect just fine during the setup wizard. I imported my users which helped and started puting everything back together. On a side-note, I wish there was a way to export-import the groups as well as the users. There’s no way to add multiple people to a group so you have to add one at at time… which gets very cumbersome.
Thanks for reading!