Microsoft SQL Server Analysis Services How To: Service Stuck At Starting

Microsoft SQL Server Analysis Services How To: Service Stuck At Starting

Was at a client recently, and after a restart the SQL Server Analysis Services could not start. We tried various things like restarting the server and stopping all services.

In the end we found a solution by doing the following:

“Go to task manager and kill Analysis services “msmdsrv.exe process”, this will stop services and then you can restart”

Reference: https://saurabhsinhainblogs.blogspot.com/2018/06/how-to-start-analysis-services-that.html