Troubleshooting
Problem
This technote explains how to resolve the errors that can occur when using IBM® Rational® ClearQuest® with Microsoft® SQL Server databases that are not set for DBOwner.
Cause
While attempting to access or upgrade a user database, you might encounter an error such as:
SQLDriverConnect: RETCODE=-1, State=37000, Native
Error=4060 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
database required.
or
Your database is in an inconsistent state
Resolving The Problem
These errors can occur if the SQL Server database is set to "Single User" or if Server Roles have been set. To resolve these errors:
- If "Single User" access is set for the database, set it back to DBOwner.
- Open the SQL server login properties for the login user. Select Server Roles and verify that all Server roles are not selected.
Note: If this error occurred during a database upgrade, and the upgrade failed, you will have to unlock your user database. See technote 1133810 for details on "How to unlock a ClearQuest database that has been locked".
[{"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;7.0.1;7.0.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21266536