SSAS– Resolving Target Machine Actively Refused

Posted in: 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)

SSAS_Error

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 (http://www.sql-server-citation.com)

Interested in working with Hemantgiri? Schedule a tech call.

About the Author

I am a Database Administrator by profession, and a student of a university called life by heart. I am open and willing to learn things as it comes and is interest to me. I am passionate about SQL Server, photography, reading and sharing. During my professional life, I have privileged to work with some great a-like-minded people from whom I learnt a lot, technical as well as soft skills; I am trying and will continue to share what all I have learnt over the years by connecting a-like-minded via many technological forums.Currently, I'm Lead Database Consultant @Pythian. I have close to 17 years of experience, about which 15 years as hard core DBA. I have been a Microsoft SQL Server MVP for four years, and a published author of the book - SQL Server 2008 High Availability; a book for SQL Server DBA aspirants, System Administrators and Developers, it provides step-by-step information to get you through the installation of various SQL Server High Availability options like Clustering, Replication, Database Mirroring and Log Shipping. Sounds interesting, read more about me at http://www.sql-server-citation.com/p/about-me.htmlSpecialties: IT Project Management, SQL Server High Availability, Performance Tuning I have worked on IT Project Management using latest tools like Six Sigma, PMP and ITIL.Keep in touch with me: Twitter: https://twitter.com/ghemant Facebook: https://www.facebook.com/SQLServerCitation

No comments

Leave a Reply

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