473,322 Members | 1,526 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL Server 2000 cannot listen on TCP/IP!

Hi all!

I just tried to enable TCP/IP on SQL Server 2000 (trial, SP3a). The
Server Network Utility shows it's already turned on, but after
restarting the server doesn't listen to any TCP port, and in the
eventlog it reports "SuperSocket info: gethostbyname(MSAFD Tcpip
[TCP/IP]) : Error 11004." and "SuperSocket info: (SpnRegister) : Error
2102.". I googled but found nothing helpful. Does anyone know what's
wrong??

The OS is Windows 2003 Server Enterprise Edition.

Jul 23 '05 #1
2 11383

"Aquila Deus" <aq*********@yahoo.co.uk> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hi all!

I just tried to enable TCP/IP on SQL Server 2000 (trial, SP3a). The
Server Network Utility shows it's already turned on, but after
restarting the server doesn't listen to any TCP port, and in the
eventlog it reports "SuperSocket info: gethostbyname(MSAFD Tcpip
[TCP/IP]) : Error 11004." and "SuperSocket info: (SpnRegister) : Error
2102.". I googled but found nothing helpful. Does anyone know what's
wrong??

The OS is Windows 2003 Server Enterprise Edition.


This KB article lists a few possibilities:

http://support.microsoft.com/kb/q307197/

If that doesn't help, could you post the relevant messages from the SQL
Server log, which should show which protocols are in use? And how have you
verified that the server isn't listening? Does netstat show the MSSQL port?

Simon
Jul 23 '05 #2

Simon Hayes wrote:
"Aquila Deus" <aq*********@yahoo.co.uk> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hi all!

I just tried to enable TCP/IP on SQL Server 2000 (trial, SP3a). The
Server Network Utility shows it's already turned on, but after
restarting the server doesn't listen to any TCP port, and in the
eventlog it reports "SuperSocket info: gethostbyname(MSAFD Tcpip
[TCP/IP]) : Error 11004." and "SuperSocket info: (SpnRegister) : Error 2102.". I googled but found nothing helpful. Does anyone know what's wrong??

The OS is Windows 2003 Server Enterprise Edition.

This KB article lists a few possibilities:

http://support.microsoft.com/kb/q307197/

If that doesn't help, could you post the relevant messages from the

SQL Server log, which should show which protocols are in use?
Shared Memory (and Named Pipe if I enable it).

It doesn't show anything like "bind failed", the gethostbyname is the
only relevant event logged.
And how have you
verified that the server isn't listening? Does netstat show the MSSQL

port?

Both tcpview and netstat show that MSSQL doesnt listen on any TCP port.
I didn't use dynamic port and force encryption.
However, I just successfully connected to it via named pipe (thanks to
a jTDS dev :).

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
0
by: Chris Halcrow | last post by:
Hi I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP. I continually get the error 'cannot configure server' just at the end of the installation. I've tried the following: ...
48
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
1
by: dschneiderman | last post by:
Hello All, I am not a SQL Server expert, but I have been put in a pretty precarious situtation and I am close to panicking :( I have need to restore a SQL database from backup (through...
1
by: tskelley | last post by:
Something strange has happened on my computer. I am unable to link tables from SQL Server 2000. I have tried from Access 97 and 2000, but keep getting the error "The Microsoft Jet database engine...
1
by: bitchanger | last post by:
I have installed an SQL Server 2000 Developer Edition (SP4) on a computer that has Windows Server 2003 on it.The server is connected to the workgroup "WORK" and has no Active Directory. Now I...
0
by: tamayi | last post by:
I have a problem (like most others posting issues on this forum :) ) I have a remote server running Windows XP SP2, with both SQL Server 2005 Express with Advanced Features and SQL 2000...
0
by: thesti | last post by:
hello, i'm trying to connect to SQL Server 2000 on my localhost through JDBC. i'm using the Microsoft SQL Server JDBC Driver 2.0 i couldnt make it, as i get the following error Unable to...
1
by: jenwil | last post by:
I have a local copnnection with Postgres setup for development on my PC. This has been working for months with the default configuration. I recently set up to access a server and got this error...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.