The included script in Openfire 4.3.2 to create the database schema for Microsoft SQL Server, openfire_sqlserver.sql is wrong. Its code syntax is for MySQL instead of MSSQL, therefore one will not be able to create the database schema required. It will generate lots of errors when executing.
I was fortunate enough to have an older installation of Openfire 4.2.3 with the correct script to use. However, that script does not contain the update to add a column to one of the tables (I don’t remember which), but errors will show up in the Openfire error logs indicating which.