SQL Server Analysis Services' state is "Change pending...", and I can't start it.
When I try to start it, they occur error, show information "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details".
Where can I see the "log" and how can solve this problem?
How can I start this service?
Here you should check error log of analysis services: Usually, you will get problem along solution, but in case log does give you specific information then.
C:\Program Files\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\Log
In case you don’t get valid information, there are 2 options left
1. Reboot server, I know that’s last option
2. Go to task manager and kill Analysis services “msmdsrv.exe process”, this will stop services and then you can restart
In my case issue was, app team was browsing cube using third party tool which was not allowing to close the connection.
Thanks. Had the same problem and after searching online, this solved the problem
ReplyDelete"Go to task manager and kill Analysis services “msmdsrv.exe process”, this will stop services and then you can restart"
Great Saurabh Sir,i have faced this issue today and went through your steps... really it worked for me.
ReplyDeleteThank you Sooo much
Amitab
Good to see , it helped.
DeleteThanks! it helped me also: "Go to task manager and kill Analysis services “msmdsrv.exe process”, this will stop services and then you can restart"
ReplyDeleteStrangely the above steps did not help in my case. I see service in change pending state and some cpu and memory usage from task manager. Last time the Cube synch job failed before this issue. Any ideas how to know what might be happening?
ReplyDeleteThis article helped me in a similar situation like yours: https://4it.com.au/kb/article/how-to-kill-a-windows-service-which-is-stuck-at-stopping/
ReplyDelete