server 2008 r2怎么配置防火墙，阻止客户端sql server数据库的连接？
server 2008 r2怎么配置防火墙，阻止客户端sql server 2008数据库的连接？
是在入站规则里设置，阻止1433端口吗？为什么不起作用？？
[解决办法]
用批处理配置ipsec吧
rem 添加策略
netsh ipsec static add policy name="sqlserver"
rem 添加规则
netsh ipsec static add filter filterlist="deny" srcaddr=any dstaddr=me dstport=1433 protocol=tcp
netsh ipsec static add filter filterlist="permit" srcaddr=111.111.111.111 dstaddr=me
netsh ipsec static add filter filterlist="permit" srcaddr=222.222.222.160 srcmask=28 dstaddr=me
netsh ipsec static add filter filterlist="permit" srcaddr=10.0.1.0 srcmask=24 dstaddr=me protocol=tcp
rem 添加动作
netsh ipsec static add filteraction name="deny" action=block
netsh ipsec static add filteraction name="permit" action=permit
rem 封装策略
netsh ipsec static add rule name="deny" policy="sqlserver" filterlist="deny" filteraction="deny"
netsh ipsec static add rule name="permit" policy="sqlserver" filterlist="permit" filteraction="permit"
rem 开启
netsh ipsec static set policy name="sqlserver" assign=y
