#
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.
#
Resolution
Follow these instructions to solve the issue:
Using the Analysis Server console application, execute the command (CreateSql):
OpeniT.Server.Etl.Console.exe CreateSql
Let the process finish, then execute the command (CreateOlap):
OpeniT.Server.Etl.Console.exe CreateOlap
Let the process finish, then execute the command (DeploySql):
OpeniT.Server.Etl.Console.exe DeploySql
Let the process finish, then execute the command (DeployOlap):
OpeniT.Server.Etl.Console.exe DeployOlap
Let the process finish.
Access the web interface again and the home page should be displayed.