Share via

How to Block an OLAP Connection to SSAS Cube using Firewall or any other method ?

Georgio Hajj Boutros 1 Reputation point
2022-08-29T15:25:55.767+00:00

We have almost 50 users that have an old excel file which has an OLAP connection to our SSAS cube, we're trying to stop the users from using that excel but they keep on using it.
They're running it from a server that can reach the SSAS Cube.

I tried to make a rule on firewall to block all incoming traffic from the IP of that server, but the excel still refreshes.

Is thre a way to block the connection completely from the SSAS server?

235776-cnx.png

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,249 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,582 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-08-30T03:38:36.89+00:00

    Hi @Georgio Hajj Boutros ,
    Successful connections to SSAS depend on valid port configuration and proper user rights.
    One way is that you revoke the user's access.
    You could also handle this by using a firewall on the server. By default, the default instance of AS uses TCP port 2383. Block access to SSAS by blocking the port that SSAS interacts with that client, but that sounds like an extreme way. For more information, please refer to: Configure the Windows Firewall to Allow SQL Server Access.
    You can also refer to the following link: Restrict/Prevent ad-hoc connections to SSAS Models.
    Best Regards,
    Joy

    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.