This page last changed on Jun 23, 2009 by rbattaglin.
 | Supported Versions Crowd supports MS SQL Server 2005 and 2008 versions. |
When you run the Crowd Setup Wizard, you will be asked to choose a database and provide configuration settings for that database. It will make things easier if you have created the database and deployed the database driver before you start the Setup Wizard.
Follow the instructions below to set up MS SQL Server for Crowd.
1. Configure SQL Server
- Create a database user which Crowd will connect as (e.g. crowduser).
 | In SQL Server, the database user (crowduser above) should not be the database owner, but should be in the db_owner role. |
- Create a database for Crowd to store data in (e.g. crowddb).
- Ensure that the user has permission to connect to the database, and create and populate tables
2. Copy the SQL Server driver to your application server
- Download the SQL Server JDBC driver from JTDS (recommended), or I-net software (commercial).
 | Microsoft have their own JDBC driver but we strongly recommend avoiding it after our JIRA customers have reported various connection errors (JRA-5760, JRA-6872), workflow problems (JRA-8443) and Chinese character problems (JRA-5054). |
- Add the SQL Server JDBC driver jar (jtds-[version].jar) to the common/lib directory.
Next Steps
Complete the Crowd installation, then start Crowd and run the Setup Wizard as described in the Installation Guide.
 | Configuring Unicode Support in MS SQL Server
To configure Crowd to support Unicode in MS SQL Server 2005 and 2008, enter the following in the 'Hibernate Dialect' field on the Crowd Setup Wizard's Database Configuration screen:
com.atlassian.crowd.util.persistence.hibernate.SQLServerIntlDialect |
RELATED TOPICS
|