Requirements
ejabberd with MS SQL Server 2000 has been tested on Microsoft Windows Server 2003. You are supposed to have Windows and SQL Server 2000 installed on your system before going further.
Database creation
We recommand to create a new database called 'ejabberd', with the SQL Enterprise Manager tool. Create a user called 'ejabberd' with password 'ejabberd'. Give this user the right of "database owner".
Two SQL scripts are needed:
- The first script defines the database structure: ejabberd_tables.sql
- The second script contains the stored procedures definition: ejabberd_procs.sql
You need to open those two file with the SQL Query Analyzer in order to create the ejabberd database.
 | Useful links In French: Microsoft SQL Server on Wikipedia. |
ODBC Configuration
You then need to create an ODBC source to access the database. You can create the ODBC configuration with the ODBC administration tool, available from "Administration tools" section in Windows control panel.
ejabberd installation
Erlang/OTP installation
You first need to install Erlang/OTP. Latest version can be obtained from Erlang web site.
The latest version is currently Erlang/OTP R10B-9: Download Erlang/OTP R10B-9 installer for Windows.
ejabberd installation on Windows
You can download the binary Windows installer for ejabberd. The installer can downloaded from Process-one web site. Latest version is currently ejabberd 1.0.0: ejabberd-1.0.0.exe
Add Comment