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