Monday, December 17, 2012

The service could not be started. Reason: Service 'MSSQLServerOLAPService' start request failed

Problem:When i try reinstall Microsoft SQL Server Analysis Services it's keep failing.


Error Message: The service could not be started. Reason:  Service 'MSSQLServerOLAPService' start request failed.
 Configuration file:C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121217_132025\ConfigurationFile.ini
Detailed results:
  Feature:                       Analysis Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xD448CDD2
  Configuration error description: The service could not be started. Reason:  Service 'MSSQLServerOLAPService' start request failed.
  Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121217_132025\Detail.txt


Workaround :
Open the Event Viewer(Administrative Tools) and Clear out all logs for
Application
Security
System

Finally restart your SQL Server Analysis Services via SQL Server Configuration Manager

References :http://richbackbi.wordpress.com/2010/12/03/mssqlserverolapservice-start-request-failed/
http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/dd04e9d8-e613-44bf-bf4a-a446efdc64aa