“Login failed for user” when configuring the Data Warehouse
Whilst configuring the Data Warehouse permissions during the setup wizard the following error is displayed:
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 Squared Up 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.
Login failed for Anonymous logon when using Windows authentication
If you are using Windows authentication and the error mentions anonymous logon then you should logon to a Squared Up server and use the localhost address to configure the Data Warehouse permissions, for example
Configuring the Data Warehouse permissions manually
If you still have problems see How to configure the Data Warehouse permissions manually.
Access denied error when viewing tiles