Share via

Cannot delete Analysis Services

Noah Cormier-Ratajczak 0 Reputation points
2024-06-03T11:48:54.8066667+00:00

I am trying to delete Analysis Services, but every time I try to, I get this error in the image below:User's image

There are no locks for Analysis Services or for my resource group, so I'm not sure what to do.

Does anyone know what could be causing this?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vidya Viraktamath 160 Reputation points Microsoft Employee
    2024-06-03T15:28:25.7466667+00:00

    Hello, The error message you’re encountering while trying to delete the Azure Analysis Services database indicates that there might be an issue preventing successful deletion. To troubleshoot this:

    1. XMLA Query for Deletion: You can try using an XML for Analysis (XMLA) query in SQL Server Management Studio (SSMS) to force delete the corrupted database. The query can be referenced from this link - https://github.com/MicrosoftDocs/SupportArticles-docs/blob/main-sync-work/support/azure/general/delete-corrupted-azure-analysis-services-database.md
    2. Restart Analysis Services: Sometimes, a simple restart of the Analysis Services can resolve transient issues. Try restarting the service and then attempt the deletion again.
    3. Check for Active Connections: Ensure that there are no active connections to the database. Disconnect any active sessions from the Azure portal or using SSMS.

    Please consider hitting Accept Answer button. Accepted answers help community as well.