SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Help! I Can’t Connect to Analysis Services in SSMS

A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well. While playing around with SSAS, I tried to open up SQL Server Management Studio (SSMS) and connect up to Analysis Services. The screenshot below shows how I tried to connect.

Connect to SSAS using SSMS

Upon clicking Connect, I was given an unexpected error. All too frequently, we receive vague errors that need decoding like we were learning how to crack the Davinci Code. But this one didn’t delay me too long. It is pretty self explanatory in that it says that the Analysis Services server does not appear to be running.


So, I navigated to the SQL Server Configuration Manager under the SQL Server menu option in windows. And as you can see by the below, sure enough…my SQL Server Analysis Services service is STOPPED! I must have forgotten that I have set this to not start automatically in order to save as many system resources as possible.

Starting The Service

Now that I need Analysis Services, I thought I better change this to automatically start for me when the system is rebooted or booted up. So, I double clicked on the SQL Server Analysis Services service and was prompted with the below.

SSAS Service

I could have just hit the Start button, but this would cause a problem after rebooting. So, I navigated to the Service tab and updated the Start Mode from Manual to Automatic.

Switch The Startup Mode

Clicking OK will only start it on the next reboot, but I wanted to use Analysis Services RIGHT NOW! So, I went back to the LOG ON tab and clicked START. You’ll see windows starting this service up like in the screenshot below.

Starting the service

After it is completed starting up, I navigated back to SSMS and tried to reconnect. If all goes well, like mine did, you’ll connect just fine. Below is showing what one might see once they connect up to their Analysis Services service.


I hope that you have enjoyed this post. If you did, please take just a moment to rate it! Also, if you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs.



Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works

Email: bmcdonald@pragmaticworks.com | Blogs: SQLBIGeek | SQLServerCentral | BIDN

Twitter: @briankmcdonald | LinkedIn: http://tinyurl.com/BrianKMcDonald



No comments.

Leave a Comment

Please register or log in to leave a comment.