INFORMATICS

The Best

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

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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

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

Search