I’m trying to setup Openfire using the Sql datebase option but can’t seem to get the connection to work. Using a Windows platform and built Openfire database with assigned user ‘sa’ and good password. Database is set to mixed mode, both windows and sql logins work. Setup reports that sa is not a trusted user but sa is what I use to connect to the Openfire database via Microsoft Sql server management studio. And the Sql error log also reports that sa is not a trusted user either. What kind of login are you using? Windows or SQL? I’m lost. It should work just fine. Does it with with SQL 2008 Server Express? I read something about a problem with using a Instance ID with the hostname but in SQL 2008 you must configure an Instance ID. Anyone have Openfire working with SQL Server that can offer some help.