TrackStudio Enterprise 3.5
Initializing an MS SQL Server Database

The following topic describes how to configure TrackStudio for use with a Microsoft SQL Server database management system.

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

Connecting to Microsoft SQL Server 2005 Express (SSE):

  1. Install SSE using Mixed Mode. Input strong password for SA (SSE will not allow for a null password) make sure to also include the SQL Browser as part of the install, it with save time later.
  2. Using MS SQL Server Management Studio Express create an empty database.
  3. In order to allow remote connection to SSE start SQL Server Surface Area Configuration:
    1. Select Surface Area Configuration for Services and Connection.
    2. Select server instance -> Database Engine -> Remote Connections.
    3. Select Local and remote connections.
    4. Select Using both TCP/IP and named pipes.
    5. Select Apply then OK.
  4. Using MS SQL Server Configuration Manager, in the right pane:
    1. Double-click TCP/IP and select IP Addresses tab.
    2. Blank out TCP Dynamic ports.
    3. Input 1433 in TCP Port.
    4. Click Apply then OK.
    5. Exit Configuration Manager.
  5. In MS SQL Server Management Studio Express:
    1. Right click database instance.
    2. On pull-down menu select Restart.
    3. Exit Server Management Studio Express.
  6. Stop TrackStudio.
  7. Using TrackStudio Server Manager, don't forget to input strong password for SA in when selecting MS SQL database.