Problem: SQL Server does not accept TCP connections

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@.pisol.com.arIts 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@.gmail.com> wrote in message
news:1167922343.027575.146800@.6g2000cwy.googlegroups.com...
> 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@.pisol.com.ar
>|||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:
[vbcol=seagreen]
> 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@.gmail.com> wrote in message
> news:1167922343.027575.146800@.6g2000cwy.googlegroups.com...|||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@.gmail.com> wrote in message
news:1167924459.305986.118040@.q40g2000cwq.googlegroups.com...
> 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:
>
>|||Kevin
You are right, I installed again SP4 and everything is working right.
Thank you very much.
Ezequiel
Kevin3NF ha escrito:
[vbcol=seagreen]
> 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.lo
g
> 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@.gmail.com> wrote in message
> news:1167924459.305986.118040@.q40g2000cwq.googlegroups.com...