Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2005
    Posts
    3

    Unanswered: SQL Server not listen on TCP/IP, help me!

    I use SQL Server 2000 as my database. I use WinXP and my computer does not connect to any network.
    But I can't telnet localhost 1433.
    When I open the file ERRORLOG, it displays:
    "2005-01-06 22:36:22.43 server SQL server listening on Shared Memory, Named Pipes."
    I checked the enable protocols, they are Named Pipes and TCP/IP and default port is 1433.
    But I can't telnet to it. I can't understand why.
    Anybody can help me? Thanks.
    Last edited by trangntt; 01-06-05 at 12:57.

  2. #2
    Join Date
    Oct 2003
    Posts
    60
    Check the ip configuration in your host (ipconfig/all). By default, DHCP is enable so if you don't have a DHCP server in your network, it will assign a faked IP address. Trying going with static config for TCP/IP.
    Also, check the Windows XP Firewall settings in the network config applet.
    jaraba

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I do not think telnet is the preferred tool to connect to SQL Server. Can you try Query Analyzer, or OSQL?

  4. #4
    Join Date
    Jan 2005
    Posts
    3

    SQL Server not listen on TCP/IP, help me!

    - When I typed "ipconfig /all" on the cmd, it displays on the screen:
    "Windows IP Configuration".
    - I can connect to Query Analyser and Enterprise Manager. After connect

    successfully, the file ERRORLOG shows that, my SQL Server only listens on

    Shared Memory, Named Pipes; not on TCP/IP.
    So I can't telnet localhost 1433 (telnet 127.0.0.1 1433 give the same result).
    - I want to connect SQL Server through jtds, it need a URL as: jdbc:jtds:sqlserver://localhost:1433/WebsiteDb). So I want my SQL Server listens on TCP/IP port 1433. What should I do now?

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Unfortunately, I am not familiar with JDBC enough to say why you can not connect with JDBC. But I can tell you that you are able to connect to the server with TCP/IP, which is the default setting during the installation. Are you getting any errors from trying to connect?

  6. #6
    Join Date
    Dec 2004
    Posts
    46
    I bet your network did not have any ip configured.

Posting Permissions

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