1
|
@echo ========= SQL Server Ports ===================
|
2
|
netsh advfirewall firewall add rule name="Open Port 80 (OSSP)" dir=in action=allow protocol=TCP localport=80
|
3
|
|
4
|
@echo ========= SQL Server Ports ===================
|
5
|
@echo Enabling SQLServer default instance port 1433
|
6
|
netsh advfirewall firewall add rule name="SQL Server (OSSP)" dir=in action=allow protocol=TCP localport=1433
|
7
|
|
8
|
|
9
|
@echo Enabling Dedicated Admin Connection port 1434
|
10
|
netsh advfirewall firewall add rule name="SQL Admin Connection (OSSP)" dir=in action=allow protocol=TCP localport=1434
|
11
|
|
12
|
|
13
|
@echo Enabling Conventional SQL Server Service Broker port 4022
|
14
|
netsh advfirewall firewall add rule name="SQL Service Broker (OSSP)" dir=in action=allow protocol=TCP localport=4022
|
15
|
|
16
|
|
17
|
@echo Enabling Transact SQL/RPC port 135
|
18
|
netsh advfirewall firewall add rule name="SQL Debugger/RPC (OSSP)" dir=in action=allow protocol=TCP localport=135
|
19
|
|
20
|
|
21
|
@echo ========= Analysis Services Ports ==============
|
22
|
@echo Enabling SSAS Default Instance port 2383
|
23
|
netsh advfirewall firewall add rule name="Analysis Services (OSSP)" dir=in action=allow protocol=TCP localport=2383
|
24
|
|
25
|
|
26
|
@echo Enabling SQL Server Browser Service port 2382
|
27
|
netsh advfirewall firewall add rule name="SQL Browser (OSSP)" dir=in action=allow protocol=TCP localport=2382
|
28
|
|
29
|
|
30
|
@echo ========= Misc Applications ==============
|
31
|
@echo Enabling HTTP port 80
|
32
|
netsh advfirewall firewall add rule name="HTTP (OSSP)" dir=in action=allow protocol=TCP localport=80
|
33
|
|
34
|
|
35
|
@echo Enabling SSL port 443
|
36
|
netsh advfirewall firewall add rule name="SSL (OSSP)" dir=in action=allow protocol=TCP localport=443
|
37
|
|
38
|
|
39
|
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
|
40
|
netsh advfirewall firewall add rule name="SQL Browser (OSSP)" dir=in action=allow protocol=UDP localport=1434
|
41
|
|
42
|
|
43
|
REM @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
|
44
|
REM netsh advfirewall set multicastbroadcastresponse ENABLE
|
45
|
pause
|