OpenFire+MS SQL Server. 'sa' login only

Hi. I have a little problem.

I configured OpenFire to work with MS SQL Server, but he work with ‘sa’ login only. If I try connect to SQ Server, I see something about this message “The OpenFire database schema does not appear to be installed”. How can I fix this?

Thanks.

Has anyone learned of a fix to this problem?

Have you specified a specific account in MSSQL for the Openfire DB? You need to do this and give that user enough rights to create and modify tables within that database.

Thanks mtstravel! Went into properties on that db and gave the necessary user all the proper permissions and it worked. Thanks!!