Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:

" 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 from Windows start menu.

  2. Select Windows Logs > Application , 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 from Windows start menu and start the Microsoft Analysis Services service . Start the service by right clicking on the service and select Start

Published:

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:

" 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 from Windows start menu.

  2. Select Windows Logs > Application , 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 from Windows start menu and start the Microsoft Analysis Services service . Start the service by right clicking on the service and select Start

For an optimal Community experience, Please view on Desktop