LogoDark mode logo
LogoDark mode logo
Contact SupportLoading Light/Dark Toggle

    • Troubleshooting licensing and activation
    • Troubleshooting users being unable to logon
    • How to check which license key is being used
    • "No license available. There are either insufficient named user licenses available, or you have been blocked from logging on to this server"
    • "License already activated" or "Maximum activations reached"
    • I've received a license expiry notification
    • An error occurred: The key provided is invalid. Activation keys must consist of at least 5 groups of letters and digits
    • This key has expired
    • "Your current license does not include the use of the EA Designer"
    • The activation key you have entered is incompatible with this version of SquaredUp DS
    • SquaredUp cannot start due to an error
    • HTTP Error 500 - The file {filename} has not been pre-compiled, and cannot be requested
    • Unable to log in post SquaredUp DSv4.4: "SCOM connectivity error: unknown or non-specific error"
    • Duplicate SPN found - Troubleshooting Duplicate SPNs
    • "Login failed for user" when configuring the Data Warehouse
    • Troubleshooting Kerberos
    • Authentication with the System Center Operations Manager server was unsuccessful
    • Users unable to logon when Kerberos constrained delegation configured
    • Users are unexpectedly logged out of SquaredUp DS
    • There are no licenses available, or the license for this user is in use elsewhere
  • Collecting diagnostic information
  • Operations Manager 2012 Data Warehouse Health Check Script
  • Where to find log files

troubleshootinguser access licensinglogin failed for user when configuring the data warehouse

"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 SquaredUp DS 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/SquaredUp/setup?stage=datawarehouse where SquaredUpServer is replaced with the name of the server where SquaredUp DS 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/SquaredUp/setup?stage=datawarehouse

Configuring the Data Warehouse permissions manually

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

Was this article helpful?


Have more questions or facing an issue?
Submit a ticket

On this page

  • Symptoms
  • Login failed for user 'domain\username'
  • Login failed for Anonymous logon when using Windows authentication
  • Configuring the Data Warehouse permissions manually

Footer

Sites

  • SQUAREDUP
  • SQUAREDUP DS
  • DOWNLOAD
  • COMMUNITY ANSWERS

Quick Links

  • SUBMIT A REQUEST
  • EVENTS
  • CAREERS

Small Print

  • PRIVACY POLICY
  • TERMS AND CONDITIONS
Youtubex (Twitter)LinkedIn

© SquaredUp 2025