티스토리 뷰
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
'Piece' 카테고리의 다른 글
| [C# & C++] unsafe keyword로 pointer 사용하는 방법 (0) | 2018.07.21 |
|---|---|
| From C# Call C++ [Hybrid] Mixing Sample (0) | 2018.07.21 |
| [Visual Studio] Dynamic/Static Library Setup Example using MySQL Connector/C++ (0) | 2018.07.09 |
| [C++] Dynamic Memory Allocation - TCHAR *myString (0) | 2018.07.09 |
| [C#] iterating enum type (0) | 2018.07.09 |