Saturday, February 28, 2015

How can create SQL Server Port ?

Step 1:
Run > services.msc > Start Windows Firewall
Step 2:
Control  Panel  > System and Security > Windows Firewall > Advanced Setting  
Step 3:
For inbound rule:
 Inbound Rules > New Rule > Port >Specific Local Port : 1544(Example) > Next .......

 
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"

No comments:

Post a Comment