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
-
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.
-
To unblock access to Analysis Services, right-click Inbound Rules and select New Rule.
-
In Rule Type, click Port and then click Next.
-
In Protocol and Ports, select TCP and then type the fixed port in Specific local ports.
-
In Action, click Allow the connection and then click Next.
-
In Profile, clear any network locations that do not apply and then click Next.
-
In Name, type a descriptive name for this rule (for example, SQL Server Analysis Services on port 54321), and then click Finish.
-
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
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
