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.
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.
- 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?
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?