Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2004
    Posts
    7

    Question Unanswered: Finding the SQL Server Port

    Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.

    Everything is on my local machine, this is a development database.

    Is there a way I can specify a port for the server to listen to?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    In Server Network Utility highlight TCP/IP and click on Properties button.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2004
    Posts
    7
    Thank you.

  4. #4
    Join Date
    Jul 2004
    Posts
    7
    Didn't work.

    I'm getting a connection refused everytime I try to connect to it via JDBC or another DB access.

    I can get to it through Enterprise Manager, but nothing else.

    I don't think the server is listening on the port specified in the network utility.

  5. #5
    Join Date
    Jul 2004
    Posts
    7
    I think the problem is that it is not listening to any port. It is listening to "Shared Memory" whatever that is.

    So I need to configure it to listen to a port.

  6. #6
    Join Date
    Jul 2004
    Posts
    7
    Does anyone have an answer to this?

    The server is not listening to a port currently. But it is listening to Shared Memory according to the logs.

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Server error log has entries at the time of service startup that indicate what protocol is used to allow user connections. You can also see it in Profiler (default template) in Audit Login/Logout entries when running it while to start EM.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  8. #8
    Join Date
    Mar 2005
    Posts
    1

    Post SQL Server Port

    By default the SQL Server is listening to TCP Port 1433, and UDP 1434

    You can change this listening port to the port you wish for by using Client Network Utility
    1. On tab general make sure that TCP-IP protocol is enabled and click the properties button and enter the port you wish the SQL Server is listening to.
    2. On tab Alias do the following
    - In Server Alias enter the name of your Server
    - In Network libraries choose TCP/IP
    - In Server name enter your Server IP Address
    - Uncheck Dyanamically determine port and enter the port number that
    you want.

    You can check this changes in the SQL Server Logs under Management Section of SQL Server Enterprise Manager.
    Last edited by Tito Tetrasuta; 03-01-05 at 04:22.

Posting Permissions

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