cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sabihpk786
Frequent Visitor

AnalysisServices:A connection cannot be made ensure that the server is running

Hello Experts ,

 

we encountered an error while trying to connect
details "AnalysisServices:A connection cannot be made ensure that the server is running

 

i want to create jet analysis report using sql server snalysis service so that actually am trying to connect through sql server analysis service but unfortunately it will not able connect 

 

please advise me how to resolve 

 

 

unabale connect sql analysis service.PNG

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @sabihpk786 ,

 

For the error 
"AnalysisServices: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Its's realted to SSAS database server. Based on my research, the issue was caused by the Browser Service account was changed to the domain account. Please try to change the service account to Local System and check if this issue persists or not.

browser-ssas-01.jpg

 

Reference
https://blog.sqlauthority.com/2015/03/10/sql-server-fix-a-connection-cannot-be-made-to-redirector-en...
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.html

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

1 REPLY 1
v-frfei-msft
Community Support
Community Support

Hi @sabihpk786 ,

 

For the error 
"AnalysisServices: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Its's realted to SSAS database server. Based on my research, the issue was caused by the Browser Service account was changed to the domain account. Please try to change the service account to Local System and check if this issue persists or not.

browser-ssas-01.jpg

 

Reference
https://blog.sqlauthority.com/2015/03/10/sql-server-fix-a-connection-cannot-be-made-to-redirector-en...
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.html

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
Changes coming soon

Coming Soon!

Check out the exciting announcements at Build surrounding the changes in the Power BI Community!

Microsoft Build 2023

Microsoft Build 2023

Attend this in-person and online event on May 23-25.

April 2023 Update

Power BI April 2023 Update

Find out more about the April 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors