"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." message appears when using Ferrysoft Help Desk Administrator.

Ferrysoft Help Desk

Ferrysoft Help Desk is a web based help desk solution. The Express Edition is free of charge. Click the screen shot to learn more about Ferrysoft Help Desk.

Symptoms

The message above appears when trying to connect to SQL Server from within Ferrysoft Help Desk Administrator.

If the message is only "Login failed for user 'sa'." then refer to the following Knowledge Base article instead.

20050405 "Login failed for user 'sa'." message appears when using Ferrysoft Help Desk Administrator.

Cause

This is caused by trying to connect to SQL Server when SQL Server is not configured for Mixed Mode authentication.

Resolution

To resolve this, refer to the appropriate guide below for details on how to setup SQL Server with Mixed Mode authentication:

How to setup Microsoft SQL Server 2005 for use with Ferrysoft Help Desk

How to setup Microsoft SQL Server 2008 for use with Ferrysoft Help Desk