SharePoint Pals
 | Sign In
Configure Windows Firewall for SQL Server Analysis Service (SSAS)
by Ahamed Fazil Buhari 21 Nov 2016
SharePoint Developer
Today  :   15     Total  :    611

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’.


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.


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


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


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.


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


7. Click on next


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


Now our SSAS will pass through the windows firewall.


Happy Coding


blog comments powered by Disqus

SharePoint Pals

SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile


Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community

SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to in a word document.

Related Resources

Recent Tweets

Twitter November 21, 21:08
Implementing Multi-Threading with MaxDegreeOfParallelism in SharePoint using CSOM – An Insight -

Twitter November 21, 12:48
Configure Windows Firewall for SQL Server Analysis Service (SSAS) -

Twitter November 21, 12:46
Implementing Multi-Threading in SharePoint To Upload Files using CSOM C# – An Insight -

Twitter November 20, 21:48
How to Get the Client Context Using App Access token, by passing Client ID using CSOM in SharePoint Office 365 -

Twitter November 18, 21:30
How to Enable Auto Approval For Permission Requests in Community Site Template – Office 2013 using Client Side Object Model (CSOM) C#

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation