Port number

• Sureshbabu Sankarasubbu

  SSC Enthusiast

  Points: 162

  More actions

  September 14, 2005 at 4:04 pm

  #91291

  hi All,

    Do you know the port number on which the sql server is running ?

  Thanks in advance

  Suresh

• Amit Lohia

  SSCertifiable

  Points: 6104

  More actions

  September 14, 2005 at 6:54 pm

  #589979

  by default on default instance the port is 1433. If you want to find the port on multiple instance. Run the below query

  DECLARE @key VARCHAR(100)

  DECLARE @PortNumber VARCHAR(20)

  SET @key = 'SOFTWARE\MICROSOFT'

  IF CHARINDEX('\',@@SERVERNAME,0) <>0

  BEGIN

   SET @key = @key + '\Microsoft SQL Server\' + @@SERVICENAME

  END

  ELSE

  BEGIN

   SET @key = @key + '\MSSQLServer'

  END

  SET @key = @key  + '\MSSQLServer\Supersocketnetlib\TCP'

  EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

   @key=@key,@value_name='Tcpport',@value=@PortNumber OUTPUT

  SELECT @PortNumber

   

   

  ---

  Kindest Regards,

  Amit Lohia

• RML51

  SSCarpal Tunnel

  Points: 4410

  More actions

  September 15, 2005 at 7:14 am

  #590124

  You can also get it from EM.  Right click the instance - Properties - Network Configuration - TCP/IP - Properties.

• krammana

  Mr or Mrs. 500

  Points: 546

  More actions

  February 1, 2008 at 12:02 pm

  #774376

  What about SQL server 2005? How to get port number of sql server 2005 instance?

• krammana

  Mr or Mrs. 500

  Points: 546

  More actions

  February 1, 2008 at 12:49 pm

  #774410

  I got the answer from this same forum....here is the method to find out port number of sql server 2005

  Sql Server Configuration Manager >

  Sql Native Client Configuration > Client Protocols

  > double-click (e.g. ) TCP/IP.

  "Default port" is top item.

  The server has it's own settings

  See

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2276a5ed-ae3f-4855-96d8-f5bf01890640.htm

  under "How To" in sql BOL

  Bill