How to find port number of SQL Server instance?

  • 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
  • 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