Mar 3 2011

SQL Server AS failed to start with 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”

Dear reader, thanks for visiting!

The post has been moved to my new blogging site – http://www.mssqlinsider.com.

You can read the complete post there.

Advertisements

4 comments on “SQL Server AS failed to start with 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””

  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.

    Reply

    • Well, the setup was pretty standard and VIA protocol is by default disabled … besides, it is not really something to be turned on, especially on a 2008 R2 SQL Server. Thanks for the suggestion, though! It might help some readers!

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s