Configuring Microsoft SQL Server

To use Rational® ClearQuest® with SQL Server databases, you must install a supported version of SQL Server on your database server.
Tip: Case sensitivity can be specified with either the installation time option or database creation time option. Case sensitivity applies to database object names and to data.
Note: For detailed instructions on completing the tasks in the following workflow, consult your Microsoft® SQL Server software documentation.
Table 1. SQL Server database configuration workflow
Task Comments
Install a supported version of SQL Server Your SQL Server databases must be in the same network domain as both your Rational ClearQuestt Web server and any Rational ClearQuest clients or tools that must connect to the database. If they are not in the same domain, errors are returned. For more information, see Technote #1133904 Accessing a Microsoft SQL Server database in another domain at: http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21133904
During the installation process, select either the Dictionary order, case-sensitive or Dictionary order, case-insensitive sort-order option

If you change the sort order after installing SQL Server, you must rebuild the SQL databases and reload the data.

Changing the sort order affects the case-sensitivity of Rational ClearQuest queries. If you want queries to not be case sensitive, set the order here.

OPTIONAL: Perform these tasks only if you are installing SQL Server 2000

Select mixed-mode authentication for Rational ClearQuest to function properly.

Select the default registration name for your database server, which makes the registration name the same as your servers host name

Verify that the computer you have installed SQL server on is registered with SQL Server. If the computer is not registered, it must be before you can begin creating the databases
Create the database containers

Create a database for the schema repository and a database for each user database.

Allocate at least 50 MB for the schema repository and at least 15 MB for every 1,000 records that you expect each user database to store.

Note: The default code page for your locale may not be compatible with your Rational ClearQuest environment. For more information, see Code pages and national language support
Create a db_owner login for each Rational ClearQuest database (schema repository and each user database). To do so, select the db_owner role for each login that you create Do not use the SA (system administrator) login. The database must be empty when you upgrade or move it. If you use the SA login, Rational ClearQuest can read the system tables and assumes that the database is not empty and does not let the process continue.

Feedback