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:
- 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
- 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.
- 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.