Results 1 to 3 of 3

Thread: how to do i check the port sql server is listening to

  1. #1
    Join Date
    Jul 2006
    Posts
    10

    how to do i check the port sql server is listening to

    when im doing telnet to my server ip & the default port for sql 1433 its given me error " could notopen port 1433 for connection". Can you please tell how do i check which port is my sql instance listening to.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can find that out from SQL Server Error Log. You should see a line like

    SQL server listening on 127.0.0.1: 1433.

    You can also go to the server and run Server Network Utility and see if TCP IP port is configured or left default. Or you can check the registry entry

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetlib\Tcp

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Or look at sql server network utility on that server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •