Re: Mysterious Port of SQL Server not shown by netstat

From: Abhishek Srivastava (abhishek-srivastava_at_nospam.net)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 14:28:25 +0530

In the general Tab. I can see that the Enabled Protocols by Order has
Tcp/Ip and Named Pipes. The port of Tcp/Ip is 1433. The default pipe for
Named Pipe is sql\query.

In the Alias tab, there is no entry.

In the Db-Librarry objects I can see

File name: c:\windows\system32\ntwdblib.dll
version:8.00.194
Date: 8/5/2000
Size 274489 Bytes

Automatic ANSI to OEM Conversion is checked
Use international Settings is checked

In Network Libraries Tab

Named Pips c:\windows\system32\dbnmpntw.dll 8.0.341 3/25/2003
Tcp/Ip c:\windows\system32\dbnetlib.dll 8.0.341 3/25/2003
Multiprotocol c:\windows\system32\dbmsrpcn.dll 8.0.341 3/25/2003
NWLink IPX/SPX c:\windows\system32\dbnetlib.dll 8.0.341 3/25/2003

My query analyzer client from local machine and remote machine
successfully connects to my server. There is a jdbc client which wants
to connect at port 1433 that fails saying could not establish network
connection at port 1433.

I did netstat -a and got completely confused when I didn't find that
port 1433 listed there... even when the sql server and query analyzer
client are working fine.

regards,
Abhishek.

Tibor Karaszi wrote:
> Did you run Server Network Utility?
>

Relevant Pages