This article only applies to Squared Up Version 2.0. If you're looking for help with Squared Up Version 3.0, please visit our new knowledge base
An error occurred: Cannot open database "OperationsManagerDW" requested by the login. The login failed. Login failed for user '<domain>\username'.
When clicking 'perform auto configuration' from the Diagnostics page, or when configuring the data warehouse permissions while running the Setup wizard following installation.
This user does have a SQL login, but the SQL login does not have the Server Role of sysadmin checked.
Make this user a SQL sysadmin user see How to make a user a SQL sysadmin user
If you still have problems configuring the data warehouse connection you can configure the permissions manually see Configuring Data Warehouse Permissions Manually.