Home > Archive > Microsoft SQL Server forum > November 2005 > connection TCP/IP through the port 1433









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author connection TCP/IP through the port 1433
Mario

2005-11-25, 7:24 am

Witam!
Mam problem z polaczeniem sie z baza danych po TCP/IP przez port domyslny
1433, nie mozna sie telnetowac ani nic z nim zrobic, poprostu niezyje. Port
jest zamkniety i nijak nie moge go zmusic do jakiejkolwiek komunikacji nawet
po localhoscie. Skaner portów wykrywa go jako zamkniety. Czy wiecie moze jak
ten port otworzyc i zmusic go do komunikacji z baza danych? OS win2k3,
MSSQL2000 Server.
Pozdrawiam

Hello!
I have a problem with a TCP/IP connection to Data Base through the 1433
port. I cannot telnet on this port even on localhost. My firewalls are
disabled but port scanner see the port as closed. Protocol TCP/IP on the
MSSQL Server is enabled and it's not hidden, so I don't know what I should
to do. My configurations: Win2k3 Server, MSSQL Server 2000
Thx for answers.


Erland Sommarskog

2005-11-26, 7:23 am

Mario (korgam@poczta.onet.pl) writes:
> I have a problem with a TCP/IP connection to Data Base through the 1433
> port. I cannot telnet on this port even on localhost. My firewalls are
> disabled but port scanner see the port as closed. Protocol TCP/IP on the
> MSSQL Server is enabled and it's not hidden, so I don't know what I should
> to do. My configurations: Win2k3 Server, MSSQL Server 2000


Which exact version of SQL Server do you have? For Windows 2003,
SQL Server RTM, SP1 and SP2 are not supported. Make sure that you have
installed SP3 or SP4.

If this does not resolve the issue, please post the beginning of the
SQL Server errorlog, down to the line "SQL Server is ready for client
connections". You find this log in C:\Program Files\Microsoft SQL
Server\MSSQL\LOG\ERR
ORLOG, assuming a standard install.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com