"Login failed for user" when configuring the Data Warehouse

Symptoms

Whilst configuring the Data Warehouse permissions during the setup wizard the following error is displayed:

An error occurred: Cannot open database "database" requested by the login. The login failed. Login failed for user 'domain\username'

The database name may differ based on your SCOM Data Warehouse database. An example screenshot of the error can be seen below:

Login failed for user 'domain\username'

If the error mentions a username, then it means that this user who you are logged on to Dashboard Server with, either does not have a SQL login in Microsoft SQL Server Management Studio, or a SQL login does exist for this user but it does not have the Server Role of sysadmin checked.

See How to make a user a SQL sysadmin.

You can return to the Data Warehouse stage of the setup wizard by browsing to http://SquaredUpServer/SquaredUpv5/setup?stage=datawarehouse where SquaredUpServer is replaced with the name of the server where Dashboard Server is installed.

Login failed for Anonymous logon when using Windows authentication

An error occurred: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

If you are using Windows authentication and the error mentions anonymous logon then you should logon to a SquaredUp server and use the localhost address to configure the Data Warehouse permissions, for example http://localhost/SquaredUpv5/setup?stage=datawarehouse

Configuring the Data Warehouse permissions manually

If you still have problems see Manually creating the Data Warehouse permissions.