SQL Server: Windows Firewall with Advanced Security

SQL Database Engine: TCP 1433 & UDP 1434

SQL Analysis Service: TCP 2383 (2382 if named instance)

 

Windows Firewall with Advanced Security

1. On Windows 7 or Windows Vista, in Control Panel, click System and Security, select Windows Firewall, and then click Advanced settings. On Windows Server 2008 or 2008 R2, open Administrator Tools and click Windows Firewall with Advanced Security. On Windows Server 2012, open the Applications page and type Windows Firewall.

2. To unblock access to Analysis Services, right-click Inbound Rules and select New Rule.

3. In Rule Type, click Port and then click Next.

4. In Protocol and Ports, select TCP and then type the fixed port in Specific local ports.

5. In Action, click Allow the connection and then click Next.

6. In Profile, clear any network locations that do not apply and then click Next.

7. In Name, type a descriptive name for this rule (for example, SQL Server Analysis Services on port 54321), and then click Finish.

8. To verify that remote connections are enabled, open SQL Server Management Studio or Excel on a different computer and connect to the Analysis Services by specifying the network name of the server and the port number in this format: <servername>:<portnumber>.

 

For more: https://msdn.microsoft.com/en-us/library/ms174937.aspx