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
- Install SQL Server with case-sensitive database collation selected
as the default setting.
- Ensure that the server security is in the mode named SQL
Server and Windows Authentication Mode.
- Enable the TCP protocol for SQL Server:
- From the Start menu, run the SQL Server Configuration Manager.
- Expand .
- Right-click the TCP/IP protocol and then
click Enable.
- Restart the SQL Server service by double-clicking SQL
Server Services, right-clicking the running service, and
then clicking Restart.
- Install the Microsoft SQL Server JDBC driver version 2.0 on the model server. This driver
is available here: SQL Server JDBC driver download
Version
3.0 is not supported; for more information, see Unable to run Rational Team Concert server using
Microsoft SQL JDBC driver 3.0.
- Log in as a user who is a member in the sysadmin fixed server role or an owner of the database.
Important: If you install Jazz™ Team Server with the Change and Configuration Management or Quality
Management applications either on the same computer or distributed
platforms, create a separate database and a user that is associated
with that database.
- Install a tool to work with the database. You can either use the sqlcmd command-line tool, which is provided with the SQL
server installation, or install SQL Server Management Studio.
To
enable the
sqlcmd tool:
- From the Start menu, run the SQL Server Configuration Manager.
- Expand .
- Double-click the Named Pipes protocol.
- Enable the named pipes protocol and specify the following name
in the Pipe Name field:
\\.\pipe\sql\query
- Click OK.
- Restart the SQL Server Service by double-clicking SQL
Server Services, right-clicking the running service, and
then clicking Restart.
- Ensure that SQL Server and SQL Server Browser are running on the
database server.
Procedure
The following instructions assume that you are using
the sqlcmd tool, but you can also use the SQL Server
Management Studio.
- 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.
- 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
- Run the following command to change the collation setting
for the database:
ALTER DATABASE JTS COLLATE SQL_Latin1_General_CP437_CS_AS
GO
- Run the following command to change the row version system
for the database:
ALTER DATABASE JTS SET READ_COMMITTED_SNAPSHOT ON
GO
- 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).
- 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
- Change the collation setting:
ALTER DATABASE <DB_name> COLLATE SQL_Latin1_General_CP437_CS_AS
GO
- Change the row version system:
ALTER DATABASE <DB_name> SET READ_COMMITTED_SNAPSHOT ON
GO
- Close the database connection with the command exit.
- If you are connecting to your SQL Server database using WebSphere® Application Server with JRE 5.0 or the version of Tomcat that is included
with theDesign Management Server , set the SQLSERVER_JDBC_DRIVER_FILE system variable on the Design Management Server to point to the JRE 5.0 version of the JDBC driver named sqljdbc.jar.
Note: Do not use spaces in file
paths to the JDBC driver. For the Program Files directory on 32-bit systems, you can use PROGRA~1. For the Program Files (x86) directory on 64-bit
systems, you can use PROGRA~2.
- If you are connecting to the SQL Server database using WebSphere Application Server with JRE 6.0 or if you want to configure your Tomcat server
to use Java Runtime Environment 6.0, perform the following steps:
- Set the SQLSERVER_JDBC_DRIVER_FILE system variable to point to the JRE 6.0 version of the JDBC driver
named sqljdbc4.jar.
- Specify the location of the JRE in the following files:

- installDir/server/repotools-jts.bat
- installDir/internal/repotools/repotools.bat

- installDir/server/repotools-jts.sh
- installDir/internal/repotools/repotools.sh
Each of these files defines a variable named
JAVA, as in the following example:
if [ `uname` = Darwin ];
then
JAVA="/usr/bin/java"
VMARGS="$VMARGS -XX:MaxPermSize=384m"
DEFINE="$DEFINE -Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true"
else
JAVA="$START_DIR/jre/bin/java"
fi
Change each assignment statement for this variable to
the location of the JRE. The resulting code looks like this, with
your JRE location in place of
jreLocation:
if [ `uname` = Darwin ];
then
JAVA="jreLocation/bin/java"
VMARGS="$VMARGS -XX:MaxPermSize=384m"
DEFINE="$DEFINE -Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true"
else
JAVA="jreLocation/bin/java"
fi
- Save and close the files.
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.