IBM Support

SQL Server does not exist or access denied error, when logging into ClearQuest

Troubleshooting


Problem

This technote explains how to resolve the error, "SQL Server does not exist or access denied". This can occur when using IBM Rational ClearQuest with Microsoft SQL Server databases.

Symptom


This error occurs when logging into the ClearQuest tools:

    Error: Exception: Unable to logon to the SQL_SERVER database ""
    The vendor error message was:
    SQLDriverConnect: RETCODE=-1, State=08001, Native Error=17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen <Connect<>>

A similar error occurs when connecting to the database using the Maintenance Tool:
    Unable to login to the database using the following connection information: DRIVER={SQL
    Server};UID=<login>;DATABASE=<database>;PWD=********;SERVER=<server>.
    Verify that the information used matches the way the database was set up.
    The error message was: SQLDriverConnect: RETCODE=-1, State=08001, Native Error=17
    [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
    [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"2003.06.16;7.0;7.0.1;7.1;7.1.1;7.1.2","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21264199

Page Feedback