IBM Support

Unable to login ClearQuest using a SQL Server back-end database

Troubleshooting


Problem

This technote explains a cause and solution for a Invalid Login error that can occur with IBM® Rational® ClearQuest® and Microsoft® SQL Server databases. This error could occur when attempting to login to the ClearQuest Client or the ClearQuest Designer.

Cause

This error can occur if the database user name or password has been changed for the back-end database has changed.

Examples of an error message that could be returned are as follows:

Warning - Invalid Login
The login name "admin" or password you entered is incorrect. Click details for more information.
SQLExecDirect: RETCODE=-1, State=S0002, Native Error=208
SQL statement="select db_locked from master_global"
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'master_global'.

or

Warning - Invalid Login
A fatal error occurred while getting the list of user databases from the schema repository.
SQLExecDirect: RETCODE=-1, State=S0002, Native Error=208
SQL statement="select db_locked from master_global"
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'master_global'

Resolving The Problem

To resolve this issue, determine if the user database name and/or password has been changed.

  1. Using the SQL Server Enterprise Manager, browse to Security and open the SQL Server Login Properties for the user database user name.
  2. If the user name is different than what is in the ClearQuest Designer, View Database Properties, then you must change the user name.
  3. If just the user password had changed, you might wish to change the password again so that you can be sure what it is. Reset the database password in the ClearQuest Designer by updated User Database Properties from the top database menu. This should allow access to the user database from the ClearQuest Designer.

Follow the Export Profile/Import Profile procedures on page 60 of the ClearQuest 2003 Administrator's guide (CQ_ADMIN.pdf) to update any ClearQuest client profiles.

[{"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":"2002.05.00;2002.05.20;2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 September 2018

UID

swg21243592

Page Feedback