-- OPENING SQL SERVER PORTS IN THE FIREWALL --
เอา code ด้านล่างไปใช้นะครับ ไม่แน่ใจว่าจะช่วยได้มากขนาดไหน
แต่ก็คิดว่าคงช่วยบางท่านได้นะครับ
<<< Code สำหรับ Command <<<<<<
@echo *** OPENING SQL SERVER PORTS IN THE FIREWALL ***
@echo source "http://rperreaux.spaces.live.com/Blog/cns!5D7BD18D324CBEEF!729.entry?wa=wsignin1.0&sa=289774293"
@echo Note for Named Instances – SQL mirroring – Dynamic Ports and the firewall
@echo see http://msdn.microsoft.com/en-us/library/cc646023(v=SQL.100).aspx#BKMK_programs
@echo You will need to open firewall ports for your mirroring endpoints and possibly dynamic ports
@echo Opening SQL Server Express 2008 R2 1433
netsh advfirewall firewall add rule name="SQL Server Express 2008 R2 (TCP 1433)" dir=in action=allow protocol=TCP localport=1433 profile=domain
@echo Opening SQL Admin Connection TCP 1434
netsh advfirewall firewall add rule name="SQL Admin Connection (TCP 1434)" dir=in action=allow protocol=TCP localport=1434 profile=domain
@echo Opening SQL Service Broker TCP 4022
netsh advfirewall firewall add rule name="SQL Service Broker (TCP 4022)" dir=in action=allow protocol=TCP localport=4022 profile=domain
@echo Port 135
netsh advfirewall firewall add rule name="SQL Debugger/RPC (TCP 135)" dir=in action=allow protocol=TCP localport=135 profile=domain
@echo Opening SQL Browser UDP 1434
netsh advfirewall firewall add rule name="SQL Browser (UDP 1434)" dir=in action=allow protocol=UDP localport=1434 profile=domain
@echo Opening Analysis Services TCP 2383
netsh advfirewall firewall add rule name="Analysis Services (TCP 2383)" dir=in action=allow protocol=TCP localport=2383 profile=domain
@echo Opening SQL Browser TCP 2382
netsh advfirewall firewall add rule name="SQL Browser (TCP 2382)" dir=in action=allow protocol=TCP localport=2382 profile=domain
@echo ***Done ***
ปล.ทำเป็น bat ไฟล์ก็ได้นะครับ
