am trying to start this services but it automatically stops - is that normal or is there a way I can start the service : MSSQLServerOLAPService (Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications.)
That is an error message but not very descriptive, huh? What about errors in the Application event log? Anything in there with more information? It sounds like permissions issue. Have you tried changing the account to LocalSystem then see if it starts? If it does, change back and test.
Thank you, from the Server manager under services - the account is being used is Local services and start up type is automatic and service start up status stopped, when I click the start service the error am getting is the service on this this server started and stopped. some services stop automatically if they are not in use by other services or program.
good day again same problem on deferent server I did a research Log Object Name: MSSQLServerOLAPService and this is what I did changed system locale from English South Africa to English US 4.Restart the System 5.Once your system is Restarted open the Registry Editor (from Start = > Run => regedit) 6.Navigate to HKEY_USERS 7.Look for LSA entry @ S-1-5-18 8.Search for LocaleName 9.Update the following keys 1.Locale = 00000409 2.LocaleName = en-US 3.sCountry = United States 1. Open the SQL Server Configuration Manager, and start the SQL Server Analysis Services rebooted server - did not come back online - I did the back up of the registry