all groups > sql server connect > january 2004 >
You're in the

sql server connect

group:

Unable to connect to 1433 port


Unable to connect to 1433 port Venkata Srinivasa Rao
1/30/2004 7:46:06 AM
sql server connect:
Dear all

We have one live server. We are not able to connect to the server neigther thru Enterprize manager nor thru Query Analyser.

This is a strange issue we are facing. This server is installed 3 months back. We did not face this issue till now

Actually, the port 1433 is enabled when we install SQL server 2000 on any system. But now if i execute

telnet <IP Address> 143

It is giving the following error
Could not open connection to the host, on port 1433: Connect faile

Any body please help us. Our live work and transactions are stopped. Please help us

Re: Unable to connect to 1433 port Linchi Shea
1/30/2004 8:18:49 AM
Check the SQL Server errorlog to see what port the
instance is currently listening on. There should be a line
near the top of the errorlog similar to the following:

2004-01-13 17:00:11.26 server SQL server listening on
127.25.109.244:1433

That last number is your TCP socket port.

There should also be a line similar to the following:

2004-01-13 17:00:11.26 server SQL server listening on TCP,
Shared Memory, Named Pipes.

This indicates what net libraries the server instance is
listening on.

Linchi
[quoted text, click to view]
the server neigther thru Enterprize manager nor thru Query
Analyser.
[quoted text, click to view]
installed 3 months back. We did not face this issue till
now.
[quoted text, click to view]
AddThis Social Bookmark Button