Skip to content

HowtoopenSQLPorttoconnectwithcontainerApplication

1. How to Enable the TCP/IP port in sql server configuration manager

Open sql server configuration manager

Click on the sql server network configuration and select the SQL name which you are using

img

Right click on TCP/IP Status ,Enable the Status and click on properties ,By default the Status is Disabled

img

Click on IP addresses and scroll down till IPAll ,and mention the TCP Port 1433(This is the default port ) you can mention any port

img

Restart the SQL server service

2. How to open SQL Port in Windows Defender Firewall to connect with container Application

Open Windows Defender Firewall

img

Select Advance Settings from the menu

img

Right Click on Inbound Rules menu and click on New Rule

img

Select Type of Rule as Port and click on Next

img

Select TCP and specify the SQL(TCP/IP) port number which you specify in sql server configuration manager

img

Select Domain,Private and Public and click on Next

img

Give the Rule name and click on Finish

img

New Rule will be show as below

img