IBM Support

SQL Server databases cannot be set to Single User nor have any server roles

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:

  1. If "Single User" access is set for the database, set it back to DBOwner.
  2. 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"}}]

Document Information

Modified date:
16 June 2018

UID

swg21266536