sql server安装后需要打开本地TCP1433-1435端口

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

经实验需要开放本地TCP的1433-1435端口,这样外界就能通过IP连接到这台服务器的数据库了

netsh advfirewall firewall add rule name = SQLPortTCP1433-1435 dir = in protocol = tcp action = allow localport = 1433-1435 remoteip = localsubnet profile = DOMAIN

posted @ 2024-09-05 11:55  techNote  阅读(10)  评论(0编辑  收藏  举报