1. Start Enterprise Manager.
2. Create the database.
3. Configure the database connection properties:
   • TrackStudio SA: Go to the Database -> Database Connectivity tab, enter the JDBC connection properties.
   • TrackStudio WAR: Edit the trackstudio.hibernate.properties:

hibernate.dialect org.hibernate.dialect.SQLServerDialect
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 -> Database Management tab and click the Create Database button.
   • TrackStudio WAR: Start Query Analyzer and execute sql\install\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 Microsoft SQL Server. If you need to store national characters in Microsoft SQL Server - please consider using a national character encoding (TIS-620 for Thai characters, for example). Change data types:

• 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.