SSAS– Resolving Target Machine Actively Refused

Posted in: Microsoft SQL Server, Technical Track

medium_5462764117I’ve always wanted to get my hands on SSAS, SSIS and SSRS as I’ve often felt shorthanded in these areas. Yesterday I decided to play around with one of these and get my hands dirty – SSAS. A few months ago I created a virtual lab on my 4 year old Dell Laptop with 3 VMs and about 4 instances of SQL Server – 2 on the Host machine and 2 on the Guest. One of them has SSAS installed on one of the named instances.

With great anticipation, I tried connecting to SSAS – it was unsuccessful!! I got an error message that says – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)


As usual, I Googled the problem and it lead me to the connect item filed by Aaron Bertrand ( Blog | Twitter ). Reading through the post, I came to understand that if I try to connect to the named instance SSAS it’s possible that I will get this very error. I also renamed my machine hence this error showed up with the named instance.

Workaround: As suggested in the comment section, I granted NTFS permission on the program files (x86)\microsoft sql server\90\shared\asconfig folder for the SQL Browser service account and it worked!!

Reference: Microsoft Connect ID 679792

photo credit: JLaw45 via photopincc

—Hemantgiri S. Goswami (

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Data Platform Consultant
I am a Database Administrator by profession, and a student at a university called life by heart. I am passionate about SQL Server, photography, reading and sharing. Currently, I'm Data Platform Consultant @Pythian. I have been a Microsoft SQL Server MVP for four years, and a published author of the book - SQL Server 2008 High Availability. Keep in touch with me on twitter @hemantgirig

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *