# Accessing Analysis Server Web Interface - Cannot open database

# Problem

There will be times that 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 there was no database created and deployed.

Analysis Server Troubleshooting: Cannot Access Database

Analysis Server Troubleshooting: Cannot Access Database

# Resolution

Follow these instructions to solve the issue:

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

    OpeniT.Server.Etl.Console.exe CreateSql
  2. Let the process finish, then execute the command (CreateOlap):

    OpeniT.Server.Etl.Console.exe CreateOlap
  3. Let the process finish, then execute the command (DeploySql):

    OpeniT.Server.Etl.Console.exe DeploySql
  4. Let the process finish, then execute the command (DeployOlap):

    OpeniT.Server.Etl.Console.exe DeployOlap
  5. Let the process finish.

  6. Access the web interface again and the home page should be displayed.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close