Setting up a SQL Server database

This topic describes how to set up a supported SQL Server® database to work with Rational Requirements Composer 2.0 Server.

Before you begin

Make sure the following prerequisites have been met before you set up your SQL Server database to work with Rational Requirements Composer Server:
Important: The default login name defined in the RRSInstallDir/server/teamserver.properties file for a SQL Server database is rrcDBuser and the default password is rrcDBpswd. These values are used in the steps below for creating a database. You should substitute these values with the user name and password for your database.

About this task

This topic describes how to set up the SQL Server database using the command line tool sqlcmd, which is provided with the SQL Server installation. You can also use a visual tool, such as SQL Server Studio Management, which is available for the Express™ version as SQL Server Studio Management Express. Refer to the SQL Server documentation or an SQL Server database administrator (DBA) for more information.

Procedure

To set up a SQL Server database:

  1. Create a RRS server database by typing the following commands from the command line tool:
    CREATE DATABASE rrc
    GO
  2. Create a user and password and change the ownership of the RRS server database by typing the following commands from the command line tool:
    CREATE LOGIN rrcDBuser
    WITH PASSWORD = 'rrcDBpswd';
    USE rrc;
    exec sp_changedbowner 'rrcDBuser'
    GO
  3. Change the collation of the RRS server database by typing the following commands from the command line tool:
    ALTER DATABASE rrc COLLATE SQL_Latin1_General_CP437_CS_AS
    GO
  4. (Optional step: Required ONLY if you are using WebSphere Application Server) Creating custom property in WebSphere: Configure the property named SQLSERVER_JDBC. Then set the property to the absolute file path (not the URL) to the SQL Server JDBC drivers directory. For more information, see the WebSphere Application Server setup instructions. Also make note of the file path for later use in these instructions.

    Return to the installation road map


Feedback