We’re upgrading your documentation experience!
A new doc website is live at docs.openit.cloud — a temporary preview during our transition. This website is now in maintenance-only mode (only critical issues will be addressed).
Explore the new website and send us your feedback!
#
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.