Connecting SQL Server Analaysis Services Engine


Dear Readers,
    Writing my article after a very long time. I am totally engaged with my office works and couldn't spend my time to my lovable SQL Server Technology. Anyway, I bagged my Microsoft award as Most Valuable Professional for the fourth year and I would like to thank Microsoft MVP Selection commitee for awarding me this award.

  Ok, here is some interesting topics. Now, am into SQL BI area :-)

Installed all the services in my machine (SQL Server DB Engine, SQL Server Analysis Services)

---------------------------------------------------------------------------------------------------------

ADDITIONAL INFORMATION:

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

------------------------------

No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)

---------------------------------------------------------------------------------------------------------

Tried to access my SSAS, I couldn't connect. I got the above error while connecting the SSAS engine.

Reason:

   1. Check your SQL Browser Services and if it's not started then start the same.

   2. The second interesting thing is :-) :-)  All the services should run under the same Service account.

Now refresh the Services.msc console. Goto your SSMS, now try to connect it...Yes, you are into the world of SQL Server Analaysis Services.

Keep watching my blog for more SSAS artciles.

Happy Learning!!!

Cheers,

Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/

Ebook Download
View all
Learn
View all