I hope someone can help, I have noticed that analysis services has stopped on two instance on my server.
For the first instance, I go to configuration manager and try to start the service I get the standard service did not respond in a timely fashion error, if I change the account that runs it from the domain user account to local system it starts up fine, but try changing it back I get the following WMI error: The server threw an exception. [0x80010105], I see this error in google but it always refers to the agent and not analysis services. In the application log, I see the following error...
The service cannot be started: Message-Handling subsystem: The message manager for the defaul locale cannot be found. The locale will be changed to US English. File system error: The following error occurred during a file operation: Access is denied.
But access denited to what? The services had been up and running for a while and nothing on the server has changed.
As on the second instance gives me the following error in the application log...
The file <path>\CryptKey.bin' could nor be opened. Please check the file for permissions or see if other applications locked it.
Then further up...
The service cannot be started: Message-Handling subsystem: The message manager for the defaul locale cannot be found. The locale will be changed to US English. File system error: The following error occurred while opening the file <path>\CryptKey.bin.
I should say the <path> part is me, saving typing not part of the error. And again, if I change the account running the service to local system if all changes and starts fine, but if I try to change it back I get WMI Error: The process terminated unexpectedly [0x8007042b]. If I hit 'apply' a second time I get another WMI Error, except this time it says 'The server threw an exception. [0x80010105].
I just dont understand why this would suddenly happen, AS on the third instance is fine.
Any help or insight would be most appreciated, and thank you for reading. I am running SQL 2008 R2 RTM (will be service packing soon) on Windows 2008 R2 SP1.