Download and extract the fixx installation as advised in the setup guide but do not run the fixx server. These steps follow on from Step 3 on the installation process for Windows and Linux.

Create a database for fixx

• Create a database user for fixx to use (e.g. fixxuser)
• Create a database for fixx to use (e.g. fixx)

Ensure that the user you created has permissions to connect to the database and create/drop tables in the newly created schema.
Ensure that TCP/IP is enabled on SQL Server and listening on the correct port.
Ensure that SQL Server is running in 'Mixed Authentication Mode'.

• Ensure that the user you created has permissions to connect to the database and create/drop tables

Download and install the SQL Server Driver

Download the SQL Server JDBC Driver and copy the JAR file for the driver into /fixx/WEB-INF/lib directory of your fixx installation.

Configure fixx to connect to SQL Server

Modify fixx/WEB-INF/classes/applicationContext-resources.xml and edit the dataSource XML specification to use the SQL Server JDBC Driver and connection details for the SQL Server DB.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="url" value="jdbc:jtds:sqlserver://localhost:1433/fixx"/>
<property name="username" value="fixxuser"/>
<property name="password" value="password"/>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>

Finally, modify fixx/WEB-INF/classes/applicationContext-dao.xml and change the hibernate.dialect setting for sessionFactory bean to org.hibernate.dialect.SQLServerDialect.

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="configLocation" value="classpath:hibernate.cfg.xml"/>
    <property name="hibernateProperties">
        <value>
            hibernate.dialect=org.hibernate.dialect.SQLServerDialect
            hibernate.query.substitutions=true 'Y', false 'N'
            hibernate.cache.use_second_level_cache=true
            hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
            hibernate.jdbc.batch_size=0
        </value>
    </property>
</bean>

Run fixx set-up

Now your database is configured, run the fixx server and the interactive set-up for your platform as described in the setup guide