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

Symptoms

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.

Cause

This user does have a SQL login, but the SQL login does not have the Server Role of sysadmin checked.

Procedure

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.


Related Articles

"An error occurred: Login failed for user" when auto configuring the data warehouse connection

How to make a user a SQL sysadmin user

Who can log on to Squared Up?