Skip to main content

Accessing Analysis Server Web Interface - Cannot Open Database

Problem​

There will be times when the Analysis Server web interface is accessed, and the page displays the error Cannot open database "database_name" by the login. It can be because no database was created and deployed.

When accessing the Analysis Server web interface, you may encounter the error Cannot open database "database_name" by the login displayed in the page. This issue occurs because no database was created and deployed.

Cannot Access Database

Cannot Access Database


Resolution​

Follow these instructions to solve the issue:

  1. Using the Analysis Server console application, execute the command CreateSql:

    CreateSQl Command
    OpeniT.Server.Etl.Console.exe CreateSql

  2. Let the process finish, then execute the command CreateOlap:

    CreateOlap Command
    OpeniT.Server.Etl.Console.exe CreateOlap

  3. Let the process finish, then execute the command DeploySql:

    DeploySQl Command
    OpeniT.Server.Etl.Console.exe DeploySql

  4. Let the process finish, then execute the command DeployOlap:

    DeployOlap Command
    OpeniT.Server.Etl.Console.exe DeployOlap

  5. Let the process finish.

  6. Reaccess the web interface, and the home page should be displayed.