sql server connect: Multiple Ports Open for the Same Connection -- sql server connect

Multiple Ports Open for the Same Connection

dj_also
6/14/2004 12:53:29 PM

sql server connect: Is this strange: "SQL server listening on TCP, TCP, Shared
Memory." ? It's SQL Server 2000 on a dual-homed W2K DC.
I have two "listening on" records for every IP. Also, the
SQL Sever application is running on the first port using
the correct IP and port # and IP 0.0.0.0 is on the second
(different) port. They only work together if I permit SQL
Svr to assign the port(s) dynamically. Otherwise, if I
assign it a static port, I get a "SuperSocket: TCP Bind
failed" error.

RE: Multiple Ports Open for the Same Connection

dj_also
6/15/2004 8:14:23 AM

the problem is that it is binding two tcp ports to all
IP's, no matter how many nics i have enabled. if i assign
a static port, it binds correctly the first time, but
fails to bind to the second port.

[quoted text, click to view]

RE: Multiple Ports Open for the Same Connection

dj_also
6/15/2004 12:53:34 PM

thanks, i checked it out. the ports are not in use and
they change every time. it's got to be something in the
SQL Server app - what could it be doing that it needs 2
ports? netstat shows the Local Address that is bound to
the port as 0.0.0.0, not 10.0.0.1 - is that any help?

[quoted text, click to view]

RE: Multiple Ports Open for the Same Connection

kevmc NO[at]SPAM online.microsoft.com
6/15/2004 6:26:59 PM

After you stop the MSSQLServer service, check to make sure the port(s) are
released.

netstat -an
or
netstat -ano

Verify that the port is not in a TIME_WAIT state before restarting
MSSQLServer.

This is the benefit of using Dynamic ports vs. Static ports. If the port
is in use during startup, it grabs the
next available port.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

RE: Multiple Ports Open for the Same Connection

kevmc NO[at]SPAM online.microsoft.com
6/16/2004 12:34:01 AM

You should see the server bind to the IP address and Loopback address.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.