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

?????? ????????? ?????? ?????????
???? ???????: 287932 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? ??? ??????? TCP/IP ????? ??????? ???? ??????? Microsoft SQL Server ??????? ??? ???? ?????. ???? ???? SQL ????????? ?? 1433? ?????? ?????? ??? ????? ???? ??????? ??? ?? 1024 ??? 5000.

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

??????? ????

SQL Server ?? ????? ?? ????? ????? Winsock ???? ??? TCP/IP ???????? ????? ???? ????? ???? ???????. ????? SQL Server ?? ??? ????????? ??????? ??? ???? ????. ?????? ????????? ? SQL Server ?? 1433. ?? ?? ?? 1433? ???? ?????? 1433 ????? ??????? ??? ???? ??????? ?????? ??? ?????? ??????? (IANA) ? SQL Server.

???? ????? ???? ??? "???? SQL" ??????? ????? ???? ?????? Dbmssocn.dll (?? Dbnetlib.dll ? SQL Server 2000) ??? ?? ???? ???????? Microsoft Data Access ?????? (MDAC) 2.6.

??? ????? ?????? ????? TCP/IP? ???? ?????? ?????-????? ????. ?????? ??? ???? ???? ????? ???? ?????? ??? ???? ????, ??? 1433 ?????????. ???? ?????? ?????? ????????? ?????? ???? ???? ?? 1024. ???? ???????? ??? ????? ????? ???? ?? ?????? ?????? ????? ?????? ??? ????? ??? ???? ??? ??? 1024 5000. ?????? ??? ???? ?? ?????????? ???? ???? Microsoft ?????? ??? ?????:
?????? ??????? TCP/IP ? Microsoft Windows 2000
?????? (?? ??? ??????? SQL Server) ?? ???? ??? ?????? ?????? ???? ???? ?? 1433 ?????? ??? ?????? ???? ????? ??????.

???? ????? ???????? ??? ?????? ????? ????? ???? ??? ???? ???????? Microsoft Network Monitor ?? ???? ????? ???? ?????. ?????? ???? ???????? ??? ?????? ???? ???? ?? * ANY * ??? 1433 ??? 1433 ??? * ANY *? ??? * ANY * ???? ???? ?? 1024.

???????? ??? ??????? ?????? ???? ????? Microsoft? ????? ???? ??????? ?????? ???????? TCP/IP Netstat ?????? ??? ??????. ????? netstat-an ????? ?? ???? ????? ?????? MS-DOS ???? ??????? ??????? ????? ??????? ??????? ????? ? SQL Server. ?????? ??? ?????? 157.54.178.42 ?????? IP ?? SQL Server 157.54.178.31 ?????? IP ??????. ?? ??????? ???????? ?? ??? ?????? 1746 ? 1748 ? 1750 ??? ???????.
Proto   Local Address          Foreign Address        State
 TCP    157.54.178.42:1433     0.0.0.0:0              LISTENING
 TCP    157.54.178.42:1433     157.54.178.31:1746     ESTABLISHED
 TCP    157.54.178.42:1433     157.54.178.31:1748     ESTABLISHED
 TCP    157.54.178.42:1433     157.54.178.31:1750     ESTABLISHED
					
??? ?????? ?????? ???? ??????? ??? ??????? ?????? ???? ?? ???? ??????? ?? ???????. ??? ??? ???? ????? ????? ??????? ?? 1433 ??? * ANY * ??? "??". ??? ???? ?????? ??????? ??? syn ??????? syn/ack ?? ???? ??? ??? ???????? ?????.

?? ???? ??? ????? ???? ?? ??? ????? TCP ?????? ????????? ????? SQL Server ???????? ??? defeat ????? ?? ?????? ?????? ????? ???? ????? ????? ??? ?????????. ??? ?? ????? TCP/IP ????? ???????? Winsock? ??? ??? ?? ???? SQL Server ?????.

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

????? ?? ???? ????????? ?????? ????? ???? ???? UDP ?????? ???????? ???? ??????? ?????? ???? UDP 1434 ?????? ??? ??????? ???? ?? ??????? ??????, ????? ?????? SQL, ??? ???? TCP ?? ???? ?????? ???? ?????? ??????? ?????? ?????? ????????. ??? ???? ??? ????? ?????? ??? ??????? ??? ??? ???? ?????? ????? ?????? ??? ???? ???? ??????? ????????? ? ?? ???? ????. ?? ????? ????? ????????? ??????? ??? ??? ?????? ??????? ??? ??? ?????? ?? ??? ?????? ????? ?????? ????? ??? ???.

?????? ??? ??????? ??????? ???? ??? ?????? ????? ??????? ???? ???????? ?? ????? ????? Microsoft:
216415HOW TO: ????? SQL Server ???????? ?????? ??????
148942 ????? ?????? ???? ???? ?????? ?? ?????? ???? ???????
169292 ??????? ????? ?????? TCP/IP
269882 HOWTO: ??????? ADO ??????? ? SQL Server ???? ???????

???????

???? ???????: 287932 - ????? ??? ??????: 24/????? ??????/1432 - ??????: 3.0
????? ???
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbsqlsetup kbinfo kbmt KB287932 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????287932

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

 

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