Login failed for user BillQuickSQL. After upgrading BillQuick from a previous version using an SQL backend, the BillQuickSQL user is receiving login failed error when connecting to the database.
Login Failed for user BillQuickSQL
Error Num=5
Login Failed
The BillQuickSQL account did not get properly assigned to your new database.
Follow the steps below to assign the BillQuickSQL user to your SQL database:
- Open BillQuick on the computer that is connected to your updated database.
- Go to Utilities menu > Optimize.
- Run the Optimize Other Tables option.
- When completed, you should be able to use the BillQuickSQL login with the default admin password to connect BillQuick to your SQL database.