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. |