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

2. On Windows 7 or Windows Vista, the Control Panel, click System and Security, select Windows Firewall, and then click Advanc Ed settings. On Windows Server-R2, open Administrator Tools and click Windows Firewall with Advanced Security. On Windows Server, open the Applications page and type Windows Firewall.

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

6. In the Rule Type, click Port and then click Next.

8. In Protocol and Ports, select TCP and then type the fixed port in specific local Ports.

10. In Action, click to allow the connection and then click Next.

12. In profiles, clear any network locations this does not apply and then click Next.

14. In name, type a descriptive Name for this rule (for example, SQL Server analysis Services on port 54321), and then click F Inish.

16. To verify that remote connections is enabled, open SQL Server Management Studio or Excel on a different computer and Conn ECT to the analyst Services by specifying the network name of the server and the port number in this format: <serverna Me>:<portnumber>.

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

SQL server:windows Firewall with Advanced Security