Processing error - connection cannot be made to redirector

Amy Jandreau 61 Reputation points
2022-03-18T13:54:31.56+00:00

Hi All,
In VS i opened an existing SSAS db, when i tried to process a dimension I am getting the error message " A connection cannot be made to redirector. Ensure that 'SQL Browser' SERVICE is running".

What I did
Checked the services were running, the log on for SQL Bowser was set to local system. So no issues here.

What else I did was I created a new projected and using the IMPORT Wizard , imported the same SSAS db , now I was able to process the objects. Can someone please advice what am I missing here?
Thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,290 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 37,596 Reputation points
    2022-03-21T05:47:24.947+00:00

    Hi @Amy Jandreau ,

    As you are opening an existing SSAS DB, your SSAS is in Multidimensional mode.

    Generally, if you can process the same SSAS database via IMPORT Wizard, then you should be able to process the dimension.

    You may try it again to see if you can reproduce the issue.

    The other thing is to check your SSAS server security option , see if you have server administrator permission:

    185027-0321.png

    If you are not a server administrator, you may ask the server administrator to add the permission as well.

    Regards,

    Zoe


    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.

    0 comments No comments

  2. Amy Jandreau 61 Reputation points
    2022-03-21T13:12:28.347+00:00

    @ZoeHui-MSFT thanks , i still get the same error and I am Admin on the box.
    thanks


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.