Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Analysis Services Service Will Not Start


Sometimes it is not possible to start the Microsoft Analysis Services service. When you try to manually start it under Services, you get the following error:

"The SQL Server Analysis Services (MSSQLSERVER) service on {computer name} started and then stopped.  Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."


The problem most often occurs after a re-install of SQL Server.


The workaround is to clear the application log in the Event Viewer

  1. Open Event Viewer


  2. Locate the Application log, right click it, and select Clear Log...

    You can the select Save and Clear (if you want to save the log entries before clearing the log) or just Clear

  3. Go to Services and start the Microsoft Analysis Services service


    Start the service by right clicking on the service and select Start

Was this article helpful?
0 out of 0 found this helpful