SQL Server AS failed to start with message “SQL Server Analysis Services () service on Local Computer started and then stopped. Some services stop automatically if they are not used by other services or programs”

 

This is a very strange issue I came across last week. We have a consolidation server with several 2005 SP3 instances, including couple of SSASs. Everything was going well until one reboot of the server, when neither of the analysis services was able to start. The symptoms were the following: when I tried to start the SSAS service from Services snap-in there was a message “SQL Server Analysis Services (<instance>) service on Local Computer started and then stopped. Some services stop automatically if they are not used by other services or programs” and the service remains stopped. I checked the SSAS logs, OS logs, but unfortunately the service did not even reach the point where it starts writing the log.

I tried to clear the event log of the operating system (System and Application) as it was suggested here. It did not work.

I wondered what would be my next move before calling MS Support so as last option I tried to install a brand new AS instance to see if it’s something with the current ones wrong, or there is a global OS issue. The new installation was successful, the instance was working AND MY OLD INSTANCES ALSO STARTED! Imagine my surprise! I had no idea what happened during the install that fixed my issue! Anyway, as it was working, I cleaned up my test AS instance (uninstalled it) and tried to restart the SSAS just to be sure. Guess what – it did not start at all (AGAIN!). So it was something that the uninstall did which was causing the AS not to start. So I dug deeper – during the uninstallation of SSAS besides Support files and Backward Compatibility tools, I noticed that setup is messing with OCW11 and MSXML6. I figured it would be something connected to those two thingies. I downloaded MSXML6 from here, installed it and tried again to start the services…this time it was successful.

Of course I asked around and it turned out that several days before the issue some SSAS instances were uninstalled. And as the SSAS services were running fine and not restarted until the server reboot the issue never came across.

So bottom-line is – be careful with uninstallation of SQL Server and if possible always reboot the server after uninstallation is done just to check if anything else has not been impacted. By the way, I also started to use the P4R-Gaming services as you guys requested, in my opinion, they are one of the best boosting game sited I have ever found.

2 Replies to “SQL Server AS failed to start with message “SQL Server Analysis Services () service on Local Computer started and then stopped. Some services stop automatically if they are not used by other services or programs””

  1. I experienced the same issue on Monday with Analysis services (2005 & 2008 64 Ent (2 instances)on a 2003 64 Ent O/S) not starting and basically causing huge problems with the business as they needed access to Cubes. We raised a call with MS a nice (£250) and they resolved the issue eventually with reinstalling Windows Installer as that was broken on the server and then reinstalling MSXML6.DLL.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.