Since version 1.1.2, ejabberd has support for Microsoft SQL Server (using ODBC). So, you do not need to apply the patch on this page if you are using 1.1.2 or higher.
How to Apply the Patch
- Create database and execute this SQL script: mssql.sql
- Download mssql.patch to your ejabberd/src directory.
- Apply the patch with this command:
patch -p0<mssql.patch
- Recompile ejabberd
- Create DSN to your ejabberd database
- Configure ejabberd.cfg:
- Change the "auth_method" paramater from "internal" to "odbc".
- Enter detail from above created DSN in "odbc_server" sections.
- Append "_odbc" to the following modules in the "modules" section: mod_roster_odbc, mod_offline_odbc, mod_last_odbc.
- Restart ejabberd.