Labels

How to start Analysis Services that state is "Change Pending..."?


A couple of Days back, I got this question on Technet:

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.


2 comments:
Write comments
  1. Really good information to show through this blog. I really appreciate you for all the valuable information that you are providing us through your blog. SQL server dba Online Course

    ReplyDelete
  2. Thanks. Had the same problem and after searching online, this solved the problem

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

    ReplyDelete

Please do not enter spam links

Services

More Services