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