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
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.