question

ismepopola-4101 avatar image
0 Votes"
ismepopola-4101 asked CarrinWu-MSFT answered

SSAS error

Hi, I get an error when I try to connect SSAS as below:
A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running.
Please guide me how to fix it. Thanks in advance.

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @ismepopola-4101,

Thanks for your posting.

  1. Make sure that SQL Server Analysis Service is up and running. You could confirm it from SQL Server Configuration Manager.

  2. Verify that the SQL Browser service is up and running.

  3. Make sure that there is no firewall or antivirus block the connection.

If you finished above troubleshooting steps and still cannot connect to SSAS, please right click properties in SQL Server Configuration Manager and change Built-in account to “Local System”. For more information, please refer to this blog.
144464-1.png


Best regards,
Carrin

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



1.png (13.3 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.