SQL Server configuration

[mpetite]

Hello,

I know it isn't popular at all, but my boss want me to configure Alfresco with MS SQL Server and I cannot find any documentation about it.

It is possible to do that? Does anybody know any piece of documentation that tells how to configure this database?

Thanks in advance,
Juan Pedro

[andy]

Hi

This is possible. It is the same steps as configuring any other database, as described on the wiki. We have some minor changes to the hibernate dialect.  There is an example in the file ready to use - but that is just like configuring any other dialect.

See http://wiki.alfresco.com/wiki/Database_Configuration for examples.

On the DB you need to create a user, then create a DB with this user as the owner - standard SQL server stuff. Hibernate will look after creating all the tables.

Regards

Andy