背景:
阅读新闻

防火墙开启SQL Server端口

  作者: 今日评论: [字体: ]

SQL Server服务默认端口是1433,AlwaysOn、Mirror等HA技术中用到5022端口,下面将图示说明开启1433和5022的步骤:

  1. 打开Windows Filewall with Advanced Security,点击’New Rule‘新建Inbound Rules
  2. 指定端口1433,5022 (TCP  1433, 4022, 135, 1434, UDP 1434.)
  3. 下一步
  4. 下一步
  5. 指定名称,然后点击'Finish'

 

To open the Windows Firewall item

1.On the Start menu, click Run, and then enter firewall.cpl.

2.Click OK



To add a program exception to the firewall using the Windows Firewall item in Control Panel.

1.On the Exceptions tab of the Windows Firewall item in Control Panel, click Add a program.

2.Browse to the location of the instance of SQL Server that you want to allow through the firewall, for example C:\Program Files\Microsoft SQL Server\MSSQL10_50.<instance_name>\MSSQL\Binn, select sqlservr.exe, and then click Open.

C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\sqlservr.exe

3.Click OK.


来源:
录入日期:[2019/07/22 23:12:00]
收藏 推荐 打印 | 录入:mikebai | 阅读:
文章评论      
正在加载评论列表...
评论表单加载中...