Listner Port

• nikhil.desai1

  SSCommitted

  Points: 1948

  More actions

  May 18, 2010 at 1:53 am

  #143156

  Hi,

  How can I check default Listner Port of SQL Server 2008.

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  May 18, 2010 at 2:42 am

  #1168654

  By default the port is 1433, but if it changed you can check do doing the following:

  You can open the SQL Server configuration manager and then go to SQL Server Network Configuration, select your instance, double click on TCP/IP in the right panel, go to IP Address tab and then scroll down to TCP Port.

  Hope it helps

  -Vikas Bindra

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  May 18, 2010 at 4:16 am

  #1168691

  set nocount on

  DECLARE @test-2 varchar(20), @key varchar(100)

  if charindex('\',@@servername,0) <>0

  begin

  set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'

  +@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'

  end

  else

  begin

  set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer \Supersocketnetlib\TCP'

  end

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

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

  SELECT 'Server Name: '+@@servername + ' Port Number:'+convert(varchar(10),@test)