SSAS 2016 Database Recreation

Rajesh Paruchuri 1 Reputation point

I scripted an existing database with cube and a bunch of dimensions. After deleting the existing database, I tried to run the create statement I scripted prior to dropping and it throws me an error Database doesn't exist.


SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 41,571 Reputation points

    it throws me an error Database doesn't exist.

    And, do the SSAS database exists?

  2. Joyzhao-MSFT 15,566 Reputation points

    Hi @Rajesh Paruchuri ,
    Square brackets around the catalog name in an XMLA query will cause the error to occur. See more: Analysis Services (SSAS) Error when Executing Query - User does not Have Access or Database does not Exist.
    Best Regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.