IBM Support

Creating a separate users or logins in SQL Server 2005 for each ClearQuest database

Question & Answer


Question

Is it necessary to have a separate user in Microsoft SQL Server 2005 for each IBM Rational ClearQuest database you create? Or is this only necessary for logins?

Cause

Referring to the ClearQuest Installation and Upgrade instructions, you are instructed to "Create a db_owner login for each Rational ClearQuest database... To do so, select the db_owner role for each login that you create." Does this mean that you also have to create a separate user on the database server for each created ClearQuest database? Or, just create separate logins?

Answer

SQL Server 2005 configuration included the defining of user objects and login objects. You can successfully create your ClearQuest databases by using a single user account. However, you must have a SQL login for each SQL Server database used for the ClearQuest databases.


To create logins for SQL Server 2005 with db_owner:

  1. Click Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
  2. In the Registered Servers panel, expand the Database Engine tree.
  3. Right-click the server name under the Database Engine tree. Click Connect > Object Explorer. Log in, if requested.
  4. Expand the Security folder in the Object Explorer pane. Right-click the Logins folder. Click New Login.
  5. Provide a new login name in the Login Name field.
  6. Select SQL Server Authentication. Provide the Password.
  7. Set the Default Database to the database to which the login is assigned. Leave the Default Language set to default.
  8. Select Server Roles in the Select a page pane. Verify that all Server roles are not selected.
    • No Server Roles should exist for the login accounts. Having them could cause problems with authentication, even with correctly configured roles and associations.
  9. Select User Mapping in the Select a page pane. In the Users mapped to this login field, select the databases you want the user assigned to.
  10. In the Default schema column, specify the user name for the default schema. The user name for the schema must be the same as the user login name.
  11. In the Database role membership pane, verify that only public and db_owner are selected. Click OK.


[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.0.1;7.1.0.2;7.1.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21377521

Page Feedback