Troubleshooting
Problem
A Microsoft SQL Server error, "Not associated with a trusted SQL Server connection", can occur when creating new IBM Rational ClearQuest databases.
Symptom
When trying to create a schema repository on SQL Server using the ClearQuest Maintenance Tool, you experience this error:
Connection failed:
SQL Server Error: Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection
Cause
SQL Server is not set to use both SQL Server and Windows Authentication Mode.
Resolving The Problem
To resolve this issue, follow these instructions to set User Authentication.
SQL Server 2000:
- Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.
- Right-click the Server name. Select Properties > Security.
- Under Authentication, select SQL Server and Windows.
- Stop and restart the server to take effect.
SQL Server 2005:
- Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
- Right-click the Server name. Select Properties > Security.
- Under Server Authentication, select SQL Server and Windows Authentication Mode.
- Stop and start the server to take effect.
[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Maintenance tool","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;7.0;7.0.1;7.1;7.1.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21119906