1. Start Enterprise Manager 

2. Create database. 

3. Configure the database connection properties:

• TrackStudio SA: Go to the Database Connectivity tab, enter the JDBC connection properties.
• TrackStudio WAR: Edit the trackstudio.hibernate.properties:

hibernate.dialect net.sf.hibernate.dialect.GenericDialect
hibernate.connection.url jdbc:jtds:sqlserver://127.0.0.1:1433/trackstudio
hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
hibernate.connection.username sa
hibernate.connection.password

4. Initialize the database:

• TrackStudio SA: Go to the Database Management tab and click the Create Database button.
• TrackStudio WAR: Start Query Analyzer and execute sql\en\trackstudio-mssql.sql.

To store unicode characters TrackStudio supports only UTF-8 encoding, but MS SQL supports only UCS-2 encoding. This means that you can't use UTF-8 character encoding with MS SQL. If you need to store national characters in MS SQL - please consider to use some national character encoding (TIS-620 for Thai characters, for example). Change

• varchar to nvarchar
• text to ntext
• char to nchar

data-types for storage in trackstudio-mssql.sql or in mssql.h that packed into sman.jar or just contact TrackStudio Support for more information.