BQE Knowledgebase



Login failed when connecting to SQL database

Problem: When trying to connect BillQuick to a SQL Server database, user gets this error - 

"Login failed for user 'username'. The user is not associated with a trusted SQL Server connection."

Cause: This problem is typically due to the fact that your SQL Server has been configured to operate in "Windows Authentication" mode and doesn't allow the use of SQL accounts.

Solution: Follow these steps to resolve the problem:

1. Log in as Local Administrator to your machine (SQL Server instance machine) and log in to SQL Server instance using Windows Authentication.

2. Change the Authentication Mode of the SQL Server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication).

3. Enable 'sa' login.

4. Restart the service.


Related Articles

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
3rd of October, 2013

Product
BillQuick

SQL Version
SQL 2005, SQL 2005 Express, SQL 2008, SQL 2008 Express

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

0% thumbs up 100% thumbs down (2 votes)

How would you rate this answer?




Thank you for rating this answer.

Continue