Error Message: Login failed for user 'qasUser'
Symptoms: After restoring the database to a fresh or different machine using a Quadrate backup file (qbak) file, you recieve the error message: "Login failed for user 'qasUser'."
Cause: When Data Workbench is installed, a new database user is created. When the database is restored from a previous installation, the previous user does not have access to the new database.
Resolution: A script is available for download that will re-create the qasUser in the QUADRATE database. To resolve the issue, follow the steps below:
- Download the file ReAddQASUser.sql from the bottom of this article.
- Open SQL Server Management Studio and connect to the Quadrate SQL instance.
- If SQL Server Management Studio is not available, then run cmd.exe and enter a command like this (you can also skip step 3):
- sqlcmd -E -S "localhost\QUADRATE" -i "ReAddQASUser.sql"
- This command needs to be run from the folder where the file was downloaded OR the full filepath should be specified.
- If SQL Server Management Studio is not available, then run cmd.exe and enter a command like this (you can also skip step 3):
- Open and execute the .sql script with sysadmin rights.
- Start Data Workbench.
Note: the script assumes that the default SQL Server Express instance was installed. If a custom SQL installation was used, then please contact support.