Monday, July 28, 2008

SSAS service couldnt be started after applying SQL Server 2005 SP 2

You may find errors when trying to start the Analysis Services service after you have applying SQL Server 2005 Service Pack 2 under Window Vista environment. Usually you will come across it when trying to run the User Provisioning Tool right after the SP2 installation as it requires the services to be started.

To solve the problem,

1.) Go to Control Panel->Regional and Language.

2.) Click on Administrative tab

3.) Change System Locale to English (United States)

4.) Click on Copy to Reserved Accounts, and apply it to appropriate accounts.

5.) Restart your Window and try to start the SSAS service again.

It should work fine now.


No comments: