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
(Visited 20 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *