powered by Jive Software

Plugin database scripts won't work with SQL Server Express

I got my plugin to work just fine on a Mac using MySQL. Now that I’m going on to windows, I added mypluginname_sqlserver.sql to the plugin and imported it into an Openfire instance that uses SQL Server Express. The problem is that Openfire just outputs to the log files: “Database updated failed. Please manually upgrade your database.”. It doesn’t give me a stack trace or anything. I ran my script directly on SQL Server Management Studio and it works just fine. I also tried other plugins (ClientControl to be more specific) and it’s also having the exact same issue. Are there issues with Openfire and SQL Server Express?