Step 1:
Run > services.msc > Start Windows Firewall
Step 2:
Control Panel > System and Security > Windows Firewall
> Advanced Setting
Step 3:
For inbound rule:
Step 4:
For outbound rule:
Outbound Rules
> New Rule > Port >Specific Local Port : 1544(Example) > Next
.......
Step 5:
Change SQL server port to 1544(as example)
Step 6:
Restart SQL Server Service
Test/Validation:
Step 1:
Connect SQL Server using <InstanceName>,<port>
Step 2:
Run below command in cmd to find out all ports:netstat -anr
Run below comman in cmd to find out used port:netstat -na|find "LISTEN"
Step 5:
Change SQL server port to 1544(as example)
Step 6:
Restart SQL Server Service
Test/Validation:
Step 1:
Connect SQL Server using <InstanceName>,<port>
Step 2:
Run below command in cmd to find out all ports:netstat -anr
Run below comman in cmd to find out used port:netstat -na|find "LISTEN"
No comments:
Post a Comment