Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Analysis Services Service Will Not Start


Symptoms

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:

Complete text from error message:

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.

Cause:

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

Resolution

The workaround is to clear the application log in the event viewer

  1. Open Event Viewer

    eventviewer.png

  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

    services.png



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

     
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments