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:
- SQL Server is installed.
- The SQL Server service is started.
- The SQL Server JDBC drivers are installed. For more information,
see Microsoft SQL Server JDBC Driver.
- The environment variable SQLSERVER_ABSPATH is
set to point to the directory that contains the SQL Server JDBC driver
JAR file (sqljdbc.jar).
- The TCP protocol is enabled for SQL Server.
- The Server authentication is set to SQL Server and Windows Authentication
mode.
- The user who creates the DB table has one of the following
permissions:
- A membership in the sysadmin fixed server role
- Ownership of the database (dbo)
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:
- Create a RRS server database by typing the following commands
from the command line tool:
CREATE DATABASE rrc
GO
- 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
- 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
- (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