HOW TO: ????? SQL Server ???????? ?????? ??????

?????? ????????? ?????? ?????????
???? ???????: 216415 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

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

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

??? ??? ???? ?????? Proxy Server 2.0 ??? ???? ??????? Microsoft Windows 2000 ?? ?????? ???? Microsoft ?????? ??? ????? ?????? "????? ????": http://www.microsoft.com/technet/archive/proxy/msp2wiz.mspx

?????? ?? ??? ????? ????????? ???????? ?? ??? ??????? ??? ???? ?????? ????? ????? (ISA).

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

???? ??? ??????? ????? ????? SQL Server ????????? ?? "?????? ??????" ?? ????????? ??????:
  • ???? ??????? ?????? SQL Server ???????? ??? ???? ??????? ?????? ????? ?? ????? IP ?? 209.58.170.10.
  • ??? ????????? "?????? ??????" ????? ???? ?????. ???? ???? ??????? ??? ???? ??????? ???????? ????? ?? ????? IP ?? 209.58.170.20. ???? ???? ??????? ?????? ?????? ??????? ????? ?? ????? IP ?? 157.57.25.30.
  • ????? ??? ?????? ??? ?????? ?????? ??? ???? ??????? ?????? SQL Server ?? ???? ??? ???? ???????? ??? ????????.

????? SQL Server ???????? ?????? ??????

?????? SQL Server ????????? ?? "?????? ??????" ???? ??????? ???????:
  1. ????? TCP/IP ??? ???? ??????? ?????? SQL Server Sockets ???? ?????????? ???? ???????. ?????? ????? ?????? ???? ???? SQL ??????? ?????? ????? ??????:
    1. ???? ??? TCP/IP ?? ???? ??? ?????.
    2. ?? ???? ?????? ????? ????? ????? ???? ??????? ???? ?? ??? ?? ????? ?????? ??? 1433 ?????? ????? ?????? ??? ????? IP ??????? ?? "?????? ??????" ?????????.
    ?????? ??? ?? ????? ????? IP ??? ????? IP ??????? ?????? ??????? ???? ?? ????.
  2. ???? ?? ??? ????? ???? SQL Server ????? ?? ??? ???? ???? ??????.
  3. ?? "????? ??????????" ? ?? ?????? ???? ?????? ?? ?????? ?????? ????? SQL Server.
  4. ???? ??? ????? ??????? "??????" ?? ????? ???? Winsock ?? ?? ?????? ???? ?????? ????. ?? ???? ???????? ????? ???? ??? ????? ??? ??? ??????.
  5. ????? ??? Wspcfg.ini ??????? ??? ???? ??????? ?????? SQL Server ?? ?? ???? ?? ??? ?????? ??? Sqlservr.exe ?????. ?????????? ???? ??? ?????? ?? ???? C:\Mssql7\Binn ?? SQL Server 7.0 ????? C:\Mmssql\Binn ?? SQL Server 6.5. ?????? ????? ?? ?????? ????????? ???????? ???????:
    [sqlservr] 
    ServerBindTCPPorts=Port_number 
    Persistent=1 
    KillOldSession=1
  6. ????? ?????? "???? ????" ???????? ??????? ???????? ?? ??????.
  7. ????? ????? IP (209.58.170.10) ????????? ???? ????? SQL Server ? ????? IP ??????? (209.58.170.20) ?? "???? ????" ????????? ??? ???? ?????? ???? (LAT) ??? "?????? ??????" ?????????.
  8. ???????? ???? ??????? ?????? SQL Server ?? ??????? ??????? MSPCLNT ??? ????????? "?????? ??????" ?? ?? ?????? ???? ???? Winsock.
  9. ????? ????? ???? ??????? ?????? SQL Server ????????? ??? ?????? ????? Winsock ????? ???????.

    ????? ????? ???? SQL Server ??? ?? ??? ????? ???? SQL Server ??? ??????. ??? ????? SQL Server 2000 ???? ??????? ??????:
    2002-02-12 17:11:32.28 server SQL server listening on Winsock Proxy, Shared Memory, Named Pipes. 
    2002-02-12 17:11:32.28 server SQL Server is ready for client connections 
      
    ?????? ?????? ????? ????? ?? ??? ????? IP ?? ?????? ??????. ???? ???? ???????? ???? ??????? ?????? SQL Server ??? ???? Winsock ????? ?? ????? IP ???????.
  10. ????? ????? ??? ?????? ?????? ??? ??????? ?????? SQL Server ??? ????????? "?????? ??????". ?????? ????? ???? ??????? ???????:
    1. ??? ????? SQL Server ???? ?????? ???? ?? ???? ??? ????? ??????? ???.

      ?????? ?????? SQL Server 6.5 ??? ????? ?? SQL Server ???? ????? ???? ?? ?? ???? ??? ?????? ?????? ???????.
    2. ?????? ????? ???? ??????? ?????? SQL Server "? ???? ??? ????? ???? TCP/IP ??? ????? ???? ???????.
    3. ????? ????? ?????? ???? ?? ???? ????? IP ??????? ????????? "?????? ??????" (157.57.25.30) ??? ??? ??? ?????????.
    4. ???? ?? ?? ????? ??? ???? ????? ??? ??? ?????? ??????. ?????????? ??? ?????? ?? 1433.
  11. ?? ??????? ????? ???? ?? ??????? ??? ???? ??????? ?????? SQL Server. ?????? ????? ?? ?????? ???? ??????? SQL (?? SQL Server 7.0) ?? ??? ISQL/w (?? SQL Server 6.5) ?? ?? ??????? ??????? ???? ????? ?? ?????? 10b.

???????

???? ???????: 216415 - ????? ??? ??????: 20/?? ??????/1424 - ??????: 3.6
????? ???
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft Proxy Server 2.0 Standard Edition
????? ??????: 
kbmt kbhowtomaster kbhowto kbinfo kbinterop kbnetwork KB216415 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????216415

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

 

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