Setting up an SQL Server database

To set up a SQL Server database to use with Design Management Server, you can either use the command line or a visual tool such as SQL Server Studio Management.

Before you begin

Procedure

The following instructions assume that you are using the sqlcmd tool, but you can also use the SQL Server Management Studio.

  1. On the database server, while logged in as a database administrator, open a command prompt window and run the sqlcmd command to connect to the database. For example, you can run this command:
    sqlcmd -S localhost\instanceName
    Use the name of the database instance for instanceName.
  2. While connected to the database, run the following commands to create a database and user for the Jazz™ Team Server application:
    CREATE DATABASE JTS
    GO
    CREATE LOGIN jtsDBuser
    WITH PASSWORD = 'jtsDBpw';
    USE JTS;
    exec sp_changedbowner 'jtsDBuser'
    GO 
  3. Run the following command to change the collation setting for the database:
    ALTER DATABASE JTS COLLATE SQL_Latin1_General_CP437_CS_AS
    GO
  4. Run the following command to change the row version system for the database:
    ALTER DATABASE JTS SET READ_COMMITTED_SNAPSHOT ON
    GO
  5. Similarly, configure 3 additional databases for Design Management Server (DM), the data warehouse (DW) and Configuration Management Server (VVC) substituting the <DB_name> for the names of the databases (DM, DW, and VVC).
    1. Create the database and user:
      CREATE DATABASE <DB_name> 
      GO 
      CREATE LOGIN <DB_name>DBuser
      WITH PASSWORD = '<DB_name>DBpw';
      USE <DB_name>;
      exec sp_changedbowner '<DB_name>DBuser'
      GO 
    2. Change the collation setting:
      ALTER DATABASE <DB_name> COLLATE SQL_Latin1_General_CP437_CS_AS 
      GO
    3. Change the row version system:
      ALTER DATABASE <DB_name> SET READ_COMMITTED_SNAPSHOT ON
      GO
  6. Close the database connection with the command exit.
  7. Create an environment variable named SQLSERVER_JDBC_DRIVER_FILEand point to the sqljdbc4.jar JDBC driver. The location of the driver varies depending on your installation.
    1. For WindowsClick Start > Control Panel > System.
    2. Click the Advanced tab; then click Environmental Variables.
    3. In the System variables list, click New.
    4. In the Variable name field, enter SQLSERVER_JDBC_DRIVER_FILE, and in the Variable value field type C:\Path_to_JDBC_dirver\sqljdbc4.jar.
    5. For LinuxOn Linux systems, add the following environment variable declaration:SQLSERVER_JDBC_DRIVER_FILE =.:Path_to_JDBC_dirver/sqljdbc4.jar.

What to do next

If you use the Design Management Server setup wizard to configure the server, no further database customization is necessary. This setup wizard configures the databases and creates the necessary tables.

If you are not running the setup wizard, you can customize the databases manually; for information, see Setting up an SQL Server database in the Rational® Team Concert installation documentation.


Feedback