Other Support Options
|
| • |
Listserv
Pose a question to other users. |
|
|
| Revised | : | January 6, 2006 (mc) |
| Version | : | Microsoft SQL Server 7.0 and greater |
| Revision | : | 1 |
PROBLEM: Error Message "Login failed. Reason: Not associated with a Trusted SQL Server connection"
January 6, 2006
SYMPTOMS
When logging into Microsoft SQL Query Analyzer or any ILLiad program, the error message appears "Login failed for user 'username' Reason: Not associated with a Trusted SQL Server connection".
CAUSE
The Security Authentication setting for the SQL Server is set to Windows Only. Therefore, the illiad usernames or the sa user can not connect to the database, even if the logins exist and are setup correctly.
RESOLUTION
Change the Security Authentication setting to SQL Server and Windows for the SQL Server. Open the Microsoft SQL Enterprise Manager, right click on the SQL Server icon for your ILLiad server and select Properties. Select the Security tab and choose the SQL Server and Windows radio button. Then click the OK button to save changes. Click "Yes" to re-start the SQL Service if prompted to do so. Also, be sure that the sa username within SQL Server has a secure password assigned to it and is not blank. You can change that under Security .. Logins within the SQL Server and double-clicking on the sa username to reset the password.
