BQE Knowledgebase



Login failed for user

Problem: When connecting to the SQL server, BillQuick user gets an error.

Login failed for both billquicksql and sa user.

bq sql login error.png

Solution: Follow the steps below to fix this error:

1. Try disabling Windows Firewall and attempt to connect again.  If this fails, the password used may be incorrect.
2. If you have verified it's not a firewall issue and the password is correct, the next step is to open the SQL Server Management Studio (SSMS).
3. Right-click on the SQL server where your BillQuick database is located and choose Security.

bq sql server studio.png

4. Select 'SQL Server and Windows Authentication mode'.
5. Restart the SQL server for the configuration changes to take effect.

bq sql restart.png

Once completed, you should be able to connect BillQuick to your SQL database.


Related Articles

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
3rd of October, 2013

Product
BillQuick

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

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

How would you rate this answer?




Thank you for rating this answer.

Continue