"Not Associated with a trusted SQL Server Connection" Error Solutin
When users create schema repository with MSSQL server in ClearQuest Maintainence Tool, he/she may meet the error message as below,
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
Here is the solution
http://www-1.ibm.com/support/docview.wss?uid=swg21119906
The key point is to set the authentication to mixed mode (SQL Server and Windows Authentication Mode)
No comments:
Post a Comment