Piece
[SQL Server] Enable TCP/IP Protocol & Port
More Code
2018. 7. 9. 21:14
Enable SQL Server TCP/IP Protocol
Open SQL Server Configuration Manager
Expand "SQL Server Network Configuration" and click on "Protocols for MSSQLSERVER"
Right click on "TCP/IP" and choose "Enable"
Click on "SQL Server Services"
Right click on "SQL Server (MSSQLSERVER)" and choose "Restart"
Enable TCP/IP Port for SQL Server
netsh advfirewall firewall add rule name=SQLPort dir=in protocol=TCP action=allow localport=1433 remoteip=localsubnet profile=DOMAIN
Delete TCP/IP Port for SQL Server
netsh advfirewall firewall delete rule name=SQLPort protocol=TCP localport=1433
Show Rules
netsh advfirewall firewall show rule name=SQLPort
netsh advfirewall firewall show rule name=all
Reset Windows Firewall
netsh advfirewall reset