Re: Problem: SQL Server does not accept TCP connections

Kevin
You are right, I installed again SP4 and everything is working right.

Thank you very much.

Ezequiel

Kevin3NF ha escrito:

Yes...that is the RTM version number, not sp4. Re-apply sp4 on the server.
If you are sure you already did it, look for a file in C:\windows\sqlsp.log
which is the sp4 install log

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"Ezequiel" <ezequiel.naftali@xxxxxxxxx> wrote in message
news:1167924459.305986.118040@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Kevin,

The .exe version number is: 2000.080.0194.00
(8.0.0.194)

Is that what you were asking me?

Thanks for the answer.

Ezequiel



Kevin3NF ha escrito:

Its not listening on TCP for some reason...verify that you have SQL
Server
sp3 or higher (I know you say you have SP4) by looking at the file
version
of sqlservr.exe on the server

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"Ezequiel" <ezequiel.naftali@xxxxxxxxx> wrote in message
news:1167922343.027575.146800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have a W2k3 with SQL Server 2000 SP4. I have configured the server
to use named pipes and TCP on 1433 (at least that is what the registry
and server configuration tool say)
However the server does not accept tcp connections (i tried with
telnet, query analyzer, etc).
Log says the following:

2007-01-03 19:12:55.85 server SQL server listening on Shared Memory,
Named Pipes.

0
2007-01-03 19:12:55.85 server SQL Server is ready for client
connections


Is this a SQL Server BUG or i am doing something wrong?

Thanks,

Ezequiel Naftali
enaftali@xxxxxxxxxxxx



.

Relevant Pages

  • Re: Event 5782 from NETLOGON on server boot
    ... Having done this several times in the past, I made a point of running SFC ... tend to get noticed by SFC if I reapply SP4. ... I could end up with a pristine log. ... As for load at boot time, I have SQL Server 2000 and IIS. ...
    (microsoft.public.win2000.dns)
  • SQL Server 2000 Service Pack 4
    ... applications to run on 64-bit platforms using the Windows on Windows ... SP4 addresses specific issues discovered in SQL Server ... SP4 is also the first service pack to service the ...
    (NT-Bugtraq)
  • Re: Neuinstallation
    ... Längerfristig solltest Du auch die anderen Rechner auf SP4 bringen. ... > Nach der Neuinstallation liess sich der Enterprise Manager nicht mehr ... SQL Server Verzeichnis existiereren. ... > Mit dem Aufspielen von SP2 und SP3 geht dieser Fehler auch nicht weg. ...
    (microsoft.public.de.sqlserver)
  • Microsoft SQL Server 2000 SP4 is open for Public Beta Testing
    ... Microsoft SQL Server 2000 SP4 is open for Public Beta Testing ... Sign up to test drive the newest service pack for SQL Server 2000 give us ...
    (microsoft.public.sqlserver.clustering)
  • Re: Can SQL2000 SP4 be Uninstalled?
    ... > From the Readme that comes with SP4: ... > and detach a database " in SQL Server Books Online. ... Restore the databases master, msdb, and model from the last backup ...
    (microsoft.public.sqlserver.setup)
Loading