??? ??????? TCP/IP ?? ????? ??? ??? ??? ????? ???? ????????? SQL Server

?????? ????????? ?????? ?????????
???? ???????: 328476 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? ??????? ?????? ????? ODBC ???? SQL ?? SQL Server ???? OLE DB ?????? ??????? System.Data.SqlClient ????? ????? ???? ???????? ?????? ????? ????????? ?????? (API) ?????????. ??? ????? ???? ????? ??? ????? ???? ????? ???? SQL ?????? ???? ????? ??? ??? ??????? ????? ?? ??? ????????? ????? ???? ?????. ???? ??? ??????? ??? ??????? TCP/IP ?? ????? ??? ??? ??? ??? ??????.

??????? ????

???? ?? ???? ????? ???? ????? ?????? ????? ???? ??????? SQL Server ???????? ????? ??? ?????? ??????? ???? ??????? ????? ??? ????????? ???? ???? ?????? SQL Server. ?? ???? ??? ????? ??????? TCP/IP ?????????? ???? ??????? ?? ???? ??????? ? ????????? ???? ???? ?????? SQL Server ??????? ?? ??????? ????? ????.

???? ?? ????? ??? ??????? ??? ????????? ???? ???? ??? ????? ???? SQL Server ??? ??????? ???????? TCP/IP. ???? ????? ????? ???? ????? ????? ????? ??? ????? ????? ?????????? SQL Server ???? ??? ?????? ??????? ??????? ???? ??? ??????? ?? ????? ??? ???????. ????? ??? ??????? ?????????? ????????? ???. ??? ?? ???? ???????? ???????? ?? ??? ??????? ???? Microsoft ???? ???? ???? ??? ???? ????? TCP/IP.

???? ?? ???? Microsoft ???? ????? ??????? ???? ?? ????? ????? SQL Server. ??????? ???? ???? ???? ??? ????? ?????? ????? ??? ?? ?? ???? ?????? ? SQL Server ?????? ??? ??????? ????? ????? SQL Server. ??????? ????? ????? ???? ???? ??? ????? ???? ???? ???? ??????? ??? ???? ??????? ???? ????? ??????? SQL Server. ??? ???? ??????? ??????? ?????? ????? ?????? ???? SQL 20.000 ??? ??????? ?????? ?? ????? ???? ??? ?????? TCP/IP ????? 160 ?????? ????? ?????? 23,520 ?? ???? ???? ???????. ?? ???? ????? ? ????? ??? ???????? ????? 225,129 TCP/IP ??? ?????? ? ?????? ????? ?????? 27,209,622 ?? ???? ???? ???????.

???? ??? ??? ???? ??? ??????? TCP/IP ???? ??????? ????? ????? ?? ???????? ???? SQL Server ?? ????? ???? ?? ???? ?? ????? ????? ??????? ??? ?????? ??????? ????? ??????? ???? ????? ??????? SQL Server:
SQL Server ??? ?????? ?? ??? ??????
?????? ????
??? ???? ???
???? TCP: ???? ???? ??? ????? ???? ????? (????? ????????/???? ?????/????) ????? ????????.
???? ??? ????? ????? ???? ????? ??? ????? ??? ??? ??? ???? ????? ???? ?? ???? SQL; ??? ???? ??????? ?? ????? ????? ????? ??? ??? ??? ????????? ?????? ???? ???? ?????? SQL Server ????? ?? ??????? ? ??? ??? ????????? ?????? ???? ???? ?????? SQL Server ?? ????? ??? ?????? TCP/IP ?? ???? ??? ??? ????? ?????? ??? ????????? ???? ???? ?????? SQL Server ???????? ???? ????? ??? ?????? ?? ??? ??? ????? ?????? ??? DNS. ???? ????? ?? ??? ???? ?? ???? ?????? ??? ?? ??? ???? ????? TCP/IP ??? ???? ??????? ???? ????? ??????? SQL Server ????? ?? ???? ????? ?????. ??? ???? ?? ????? ?????? ??????? ???? ????? ??????? ???? ???? ????? ??? ????? ????? ???. ?? ???? ???? ???? ????????? ?? ??? ???? ????? ?? ???? ??? ????? ?? ????? ????????? ????? ?? ??? ????? ??? ????? ?????? ?? ??? ???? ?????. ?????? ????? ???? ???? ??? ??????? ?????? ??????? ?? SQL Server ???? ??????? ???? ? ???? ?????? ?? ???? ??????? ?????? ??? ????. ????? ???? ???????? ???????? ??????? ???? ??????? ???? ????? sporadically ???? ??????? ?????? ??????? ?????? ?? SQL Server ????? ?? ???? sporadically.

???? ?????? ????? ??????? ??????? ????? ????? ??? ????? ???? ????? ??????? ???????? TCP/IP ???? SQL: ?????? ????? ?? ??????? ??????? ??? ???? ????????? ?????? ?? ?? ?????? ????? WinsockListenBacklog ????????? ??? ??????? ???? ????? ??????? SQL Server.

?????? ??? ??????? ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
319502PRB: 'WSAEADDRESSINUSE' ????? ??? ??? ?????? ??????? ??? ???? ????? ??? ????? ????? ?? ??????? IMAP

??? ??????? MaxUserPort TcpTimedWaitDelay

???? ?? MaxUserPort ???????? TcpTimedWaitDelay ????? ??????? ??? ??? ??????? ???? ????? ??? ???? ????? ??????? ??? ??????? ???? ???? ????? ??????? SQL Server ? ???? ?? ?????? ????? ???????. ??? ???? ??????? ????? ??????? ??? ???? ????? ??????? ?????? (IIS) ???? ???? ????? ??? ???? ?? ????? HTTP ?????? ?? ??? ??? ?? ????? ??????? ??? ??????? ???? ???? ????? ??????? SQL Server ? ???? ?????? ???????? TCP/IP ?? ???? ????? ??? ?????????. ??? ?? ????? ???? ??? ???? ???? MaxUserPort ???????? TcpTimedWaitDelay.

??? ??????? ???????? TCP/IP ??? ????? ????? ??????? ???? ????? ??????? SQL Server ????? ???? ???? SQL ?????? ??? ???? ????? TCP/IP ??? ???? ??????? ???? ????? ??????? SQL Server. ??? ???? ???? ??????? ??? ????? ???? SQL Server ?? ???? ??? ????? ???? ???? ??????? SO_REUSEADDR TCP/IP. ?????? ??? ???? ?? ????????? ??? ????? ???? ??????? SO_REUSEADDR ???? ??????? "Setsockopt" ?? ???? ????? Microsoft (MSDN).

???? ?? ????? ???? ???? SQL ???? ??? ??? ????? ?????? ???? ??????? TCP/IP SO_REUSEADDR ?????? ?????. ??? ????? SO_REUSEADDR ???? ??????? ??? hijack ???? ???? ??? ???? SQL ??????? ????? ???????? ???? ???? ?????? ?????? ??? ??????? ???? ????? ??????? SQL Server. ???? ???????? ??? ????? ???? SQL Server ?? ??? ?????? ?????? ???? ??????? SO_REUSEADDR ?? ??? ??? ???? ??? ???? ????? ???? ????? ???? SQL Server ??? ???? ?????? ??????? ???? ???? ??????? ???? TIME_WAIT ????? ?????. ??? ??? ????? ??? ?? ????? ??????? SQL Server ??? TCP/IP ?? ???? ????? ? ????? ????? ??? ???? ????? ???? ??????? TCP/IP. ?????? ???? ????? ?? ????? SQL Server ???? ??????? TCP/IP ????. ??? ??? ????? ??? ??????? ???? ????? 4000 ?? ??? ?? ????? ????? ???? ?????? ??? ????? ???? ?????? ????????? ????? ?????? ????? ? ???? ??????? ????? ???? ??????? ??????? ??? ???????? ??????? ?? ???? ??????? TIME_WAIT ????.

??? ???? ?????? ?? ????? ??? ????? MaxUserPort ???????? TcpTimedWaitDelay ???? ??? ???????? ?? Q319502 ????? ???? ???? ???? ?????. ??? ????? ??????? ??? ????? ?????? ????? SQL Server ??? ??? ?? ????? ???? ??? ???? ??????. ????? ??? ?? ??? ??????? ?????? ?? ???? TIME_WAIT ???????? ???? Netstat ??? ???? ????????? ??????. ?? ?????? ?????? Netstat ????? - n ??? ??? ?? ?? ????? ??? ???? ?????? ??? ????? IP ???? SQL ?? ???? TIME_WAIT. ?? ??? ?????? ?? ????? IP ????????? ?????? ???? ???? ???? SQL 10.10.10.20 ? ????? IP ???????? ?????? ?? 10.10.10.10 ????? ??????? ??????? ??????? ?? ???? TIME_WAIT:
C:\>netstat -n

Active Connections

  Proto  Local Address         Foreign Address       State
  TCP    10.10.10.10:2000      10.10.10.20:1433      ESTABLISHED
  TCP    10.10.10.10:2001      10.10.10.20:1433      ESTABLISHED
  TCP    10.10.10.10:2002      10.10.10.20:1433      ESTABLISHED
  TCP    10.10.10.10:2003      10.10.10.20:1433      TIME_WAIT
  TCP    10.10.10.10:2004      10.10.10.20:1433      TIME_WAIT
				
?? ???? ????? netstat n ??? ?? ?????? ?? 4000 ??????? IP ????? ????????? ????? ???? ???? ?????? SQL Server ?? ???? TIME_WAIT ????? ?? ?????? ????? MaxUserPort ????????? ?? ????? ????? TcpTimedWaitDelay ???? ?? ??? ?????? ?? ????? ?????? ?????. ??? ???? ??????? ????? ????? ??????? MaxUserPort ??? 20000 ?????? ????? ??????? TcpTimedWaitDelay 30. ???? ????? TcpTimedWaitDelay ??? ????? ???? ??????? ?? ???? TIME_WAIT ??? ??? ???. ???? ????? MaxUserPort ???? ???? ???? ???? ?? ???? ??????? ?? ???? TIME_WAIT.

???? ??? ??? ??? ????? MaxUserPort ?? TcpTimedWaitDelay ??? ????? ????? Microsoft Windows ??????? ?????? ???? ???????. MaxUserPort ???????? TcpTimedWaitDelay ?? ??? ?? ??????? ???? ?????? ??? ??????? ???? ?????? SQL Server ??? ???? ????? TCP/IP. ?? ???? ??? ????????? ?? ????? ?? ???? ????? ??? ???? ????????? ???? ?????? SQL Server ??? ??? ??? ???? ???? ??????? ???? ??????? TCP/IP ?????? ??? ????????? ?????? ???? SQL Server.

?????? ?? ???? ??? ????? MaxUserPort ???? ??? ?????? 1434 ????????? ?????? ???? ?????? SQL Server (sqlbrowser.exe). ????? ?? ????????? ??? ????? ?????? ????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
812873????? ??? ???? ??????? ??????? ??? ???? ??????? ???? ????? ??????? Windows Server 2003 ?? Windows 2000 Server

??? ????? WinsockListenBacklog

?????? ??? ??????? ?????? ??? ????? ??? ??????? ?????? ?? SQL Server "? ???? ??? ??? ??????? ????? ?????? ??" ????? ??????? ?? Microsoft:
154628INF: ????? SQL 17832 ?? ????? ??????? TCP\IP ??????
??? ????? ????? ???? SQL Server ??? ???? TCP/IP ? ?????? ????? ???? SQL Server ?? ???????? Winsock API. ?? ??????? ??????? ?? ??? ???????? API backlog ??????? ??? ??? ???? ???????. ???? ??? backlog ???? ??? ????? ?????? ??????? ??????? ???? ???????. ????? ?????? ??? ????? ???????? ??? ???? ?????? ????? ? ???? ????? ???? SQL Server ?????? ?? ??????? ??????? ???? ??????? TCP/IP. ???????? ??? ???? ???? ????? ???? SQL Server ???? ACK + RESET.

?????? SQL Server 2000 ????????? ???????? ??????? backlog ?? 5. ???? ???? ?? ????????? ???? ????? ??????? SQL Server ?????? ?????? 5 ??? ????? backlog ?? ???????? Winsock API ??? ???????? API ?????? ????? ??????? ???????? TCP/IP ??? ???? ????????? ???? ???? ?????? SQL Server. ????? ??? ????? ??????? WinsockListenBacklog ?????? ???? ?????? ??????? ???? ???????. ??? ????? ?? SQL Server 2005 ????? ???? ?????? ???? SOMAXCONN ?????? backlog ???????? API. ???? SOMAXCONN ???? Winsock ????? ???? ?????? ?????? ???? ???????. ????? ????? ??????? WinsockListenBacklog ?? ??? ??????? ?? ???????? ?? SQL Server 2005.

backlog ????? ???? ??? ???: ???? ????? ???? ??????? ????? ???? ??????? TCP/IP ???????. ?? ???? ????? ????? backlog ??? 5 ???????? ?? ??? ?????? ?? ????? ????? ???? ??????? ?? ?? ?? ????? ?????? ?? ????????? ?????? ??????? ??? ???? ??????. ??? ??? ??????? ???? ???? ??????? TCP/IP ????? ???????? ??? ??????? ??????? ?? ????? ?????? backlog ?? ???? ???? ?????? ???? ??? ??? ??????? ?? ????? ???????? ??? ??? ????? ???? ??????? ?????? ?????????. ??? ???????? ???????? ???? ???? ??????? TCP/IP ?????? ??? ?? ????? ?????? ???? ??????? ???? ???? ??? ????? ???? ACK + RESET ??? ??????. ????? ????? ??? ????? ?????? backlog ????? ??? ??????? ??????? ??????? ????? ???? ???? ??????? TCP/IP ???????? ??? ?? ??? ??? ?????.

???? ?? ??????? WinsockListenBacklog ???? ?? SQL Server. ????? SQL Server ????? ??? ??????? ??????? ??? ??? ????? ???? SQL Server. ??? ??? ??????? ??? ?????, ??? ??????? ????????? 5. ?? ???? ???? ????? ??????? ???? ??????? SQL Server ? ?????? ?????? ??? ???? ??????? backlog ??? ???????? API WinSock ??? ?? ????? ???????? ???? ??????? TCP/IP ?????? ??????? ???? SQL Server.

?????? ?? ??? ??? ???? ?????? ?? ??? ??????? ????? ????? ???? "????? ???? ???????" ??? ?????? ?? ???? ??????? ???? ????? ??????? SQL Server ?? ???? ?? ????? ??????? ???? ??????? ???? ?? ????? ?????? ?? ACK + RESET. ??? ??? ??? TCP/IP ?? "?????? ??????", ???? ???? ??? ??? ??? ???? ??? ???????:
Frame: Base frame properties
ETHERNET:  EType = Internet IP (IPv4) 
IP: Protocol = TCP - Transmission Control; Packet ID = 40530; Total IP Length = 40; Options = No Options
TCP: Control Bits: .A.R.., len:    0, seq:         0-0, ack:3409265780, win:    0, src: 1433  dst: 4364 
  TCP: Source Port = 0x0599	
  TCP: Destination Port = 0x110C
  TCP: Sequence Number = 0 (0x0)
  TCP: Acknowledgement Number = 3409265780 (0xCB354474)
  TCP: Data Offset = 20 bytes
  TCP: Flags = 0x14 : .A.R..
    TCP: ..0..... = No urgent data
    TCP: ...1.... = Acknowledgement field significant
    TCP: ....0... = No Push function
    TCP: .....1.. = Reset the connection
    TCP: ......0. = No Synchronize
    TCP: .......0 = Not the end of the data
  TCP: Window = 0 (0x0)
  TCP: Checksum = 0xF1E7
  TCP: Urgent Pointer = 0 (0x0)
				
???? ?? ?????? ?????? ?? 0x599 ?? 1433 ???????? ???????. ???? ???? ?? ???? ?????? ?? ??????? ??????? ???? ????? ??????? SQL Server ? ???? ???? ??? ?????? ????????? 1433. ???? ????? ????? ????? ??? ??????? ? ?????? ????? ????? ???????. ??? ??? ??????? ??? ????? ???? "????? ??????" ????? ????? ???? ?????? TCP 0x14 ???? ???? ???? ??? ACK + RESET ??? ?? ???? "?????? ???? ???????".

???? ??? ????? ????? ?????? ????? ACK + RESET ?????? ??? ?? ??? ????? ???? ????????? ???? ???? ?????? SQL Server ?? ???? ?? ??? ?? ??? ???????? ??????? ???? ????? ??????? SQL Server ??? ???????? TCP/IP ??? ?????? ????? ACK + RESET ??? ????? ??????? ???? ????? ??? ???????. ?? ???? ?????? ???? WinsockListenBacklog ??????? ??? ??????? ???? ???? ??? ??? ??????? ?????? ACK + RESET ??? ??????? ?? ??? ???? ????.

???? ??? ?? ??? ??????? ???????? ?????? ?? ????? ??? ??? ??? ??????? ??? ??? ???? ??????? ??? ????? ????????? ???????. ??? ???? ??????? ??? ??? ?????? ?? ????? ????????? ??????? ????? ???? ??????? ???? ???? ????? ??????? SQL Server ??? ???? ?? ??????? ??????? ?????? ????????? ?? ???? ?? ?? ??? ???? ??? ??? ?? ????? ????.

???????? ???? ??? ????? WinsockListenBacklog ??? ???? ??? ????? ????? Windows ??? ??????? ???? ???????. ??? ???? ?? ??? ????? ???? SQL Server ??????? ???? ???????. ??? ????? ??????? WinsockListenBacklog ??? ?? ??? ??????? ???? ????? ??????? SQL Server. ?? ??? ?? ????? ??? ?? ??????? ???? ?????? ??? SQL Server.

???????

???? ???????: 328476 - ????? ??? ??????: 04/????/1430 - ??????: 11.0
????? ???
  • Microsoft ODBC Driver for Microsoft SQL Server 3.7
  • Microsoft OLE DB Provider for SQL Server
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft ADO.NET 1.0
  • Microsoft ADO.NET 1.1
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbinfo KB328476 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????328476

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com