Configure Windows Firewall for SQL Server Analysis Service (SSAS)


Ahamed Fazil Buhari
SharePoint Developer
Published On :   21 Nov 2016
Visit Count
Today :  2    Total :   2012
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

Sharegate: Kick-Ass Tool
Think Your SharePoint & Office 365 Are Secure ? Find Out Now!


Title: Configure Windows Firewall for SQL Server Analysis Service (SSAS)

In one of my previous article “Installation of SQL Server Analysis Service (SSAS) – SQL Server 2012”, in step 4 we had a warning ‘Windows Firewall’ when we install SSAS. In this article we’ll see how to rectify that warning.

1. Go to Start -> select ‘Windows Firewall with Advanced Security’.

clip_image001

2. Go ahead and create new Inbound Rule, if you notice that we already have ‘Allow Inbound 1433’ and this set up was happened when we initially installed our SQL Server on this machine.

clip_image003

3. But our SQL Server Analysis Services also needs to have a new port. For that click on Inbound Rule -> New Rule

clip_image005

4. New Inbound Rule Wizard window will populate and select Port for rule type and click Next

clip_image007

5. In Protocol and Ports steps, select TCP and specify the local ports value as 2383 (Note: port for SQL Server Analysis Service is 2383), we’re going to allow traffic through that port and click on Next.

clip_image009

6. Click on Next for Action, Profile steps as there are no changes.

clip_image011

7. Click on next

clip_image013

8. In final step, provide the Name and the Description (optional) and click on Finish

clip_image015

Now our SSAS will pass through the windows firewall.

clip_image017

Happy Coding

Ahamed

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

Migratiin Tools for SharePoint