Problems faced while starting the SQL Server Analysis Services

Recently i faced an issue where i wanted to start the sql server analysis services but it didnt. I had to go back to the error log and search what went wrong with the services. After some time i found the below entries in the log.

" The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Errors in the metadata manager. LOG file extension can be only .LOG. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the 16393 locale cannot be found. Internal error: Failed to generate a hash string "


If such logs are found in the error log, u can go ahead and  implement the below steps :

1. Open Control Panel
2. Go to Regional and Language Options Locale Settings
3. Change the Format, Location and Administrative from English(India) to English(United States)
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 
10. Open the SQL Server Configuration Manager, and start the SQL Server Analysis Services