- Click Start > All Programs > Microsoft SQL Server <2005 / 2008 / 2012> > Configuration Tools >SQL Server Configuration Manager
- Go to SQL Server Configuration Manager > SQL Server Network Configuration >Protocols for <Instance Name>
- Right Click on TCP/IP and select Properties
- In TCP/IP Properties dialog box, go to IP Addresses tab and scroll down to IPAll group.
- If SQL Server if configured to run on a static port it will be available in TCP Port textbox. If it is configured on dynamic port then current port will be available in TCP Dynamic Ports textbox
