Friday, April 3, 2009

Problem Starting SQL Server Analysis Services.

For those who are facing problem in Starting SQL Server Analysis Services, please follow the following steps to fix the issue.

  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.

FYI: This is caused because Windows Vista is supporting en-IN whereas SQL Server 2005 does not provide support for en-IN, so while doing the SQL Server Surface Area configuration, if you try to run SQL Server Analysis Services it will give the following exception (can be found in Event Viewer)

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.

0 comments:

Post a Comment