Creating A Separate Users Or Logins In SQL Server 2005 For Each ...

IBM Support

No results were found for your search query.

Tips

To return expected results, you can:

• Reduce the number of search terms. Each term you use focuses the search further.
• Check your spelling. A single misspelled or incorrectly typed term can change your result.
• Try substituting synonyms for your original terms. For example, instead of searching for "java classes", try "java training"
• Did you search for an IBM acquired or sold product ? If so, follow the appropriate link below to find the content you need.

Our apologies

Search results are not available at this time. Please try again later or use one of the other support options on this page.

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"}}]

Was this topic helpful?

Not usefulUseful

Document Information

Modified date: 16 June 2018

UID

swg21377521

Page Feedback

Share your feedback

Need support?

• Submit feedback to IBM Support

• 1-800-IBM-7378 (USA)

• Directory of worldwide contacts