Pages

Monday, 16 September 2013

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

No comments:

Post a Comment