Alfresco + JBoss portal with MS SQL 2000

[solocharbel]

Hi guys,
I want to try alfresco for jboss portal with sql 2000 database but I didn't find any help on the website after searching.
If anyone knows about a link to a document that can be helpful I would appreciate it.

Thanks in advance.

[kevinr]

There are a few small steps needed to use a different database such as MS SQL Server, they are:

1. Download/aquire the JDBC driver for your DB
2. Set the Alfresco server Hibernate dialect for your DB
3. Change the server settings to use the correct DB name and JDBC connection string
4. Modify the database setup script for your DB if required

An example for changing the DB to Oracle is here:
http://www.alfresco.org/mediawiki/index.php/Database_Configuration

There are several forum articles for other databases including Sysbase, Postgres etc. generally the steps are pretty similar.

Hope this helps,

Kevin