"?????? ???????" "??? ??? ???????" ?? "??? ????? ???" ????? ????? ??? ????? ????? ????? SQL

?????? ????????? ?????? ?????????
???? ???????: 942861 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

?????? ??? ??????? ????????? ???????:
  • ??????? ???? ??? Microsoft ????? ????? ?????? Pack (SNP)
  • ??????? ???? ?? ???? ??????? ????? ?? ??? ??????? ????? ?? Microsoft SQL Server ???? ??? ????????? ??? ???? ??????? ????? ??? Windows ????? ??? ??? ?? ???? ??????? ???? ????????? ?????

    ?????? ????? ??? ??????? ???? ?????? ???? ??? ??????? ??? ????? ????????? ???? ???? ?????? ??????? ?????? ?? Windows.
  • ????? ??????
?????? ??????? ?????? ?? ??? ??????? ????? ???? ??? ????? ??????? ?????? ?????? ?? ????? ???????? ??????????.

??????? ????

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

?? SNP ?????? ?? ????? ????? ????? ?????? ???? ?? ??????? ???? ?? Windows Server 2003 Service Pack 2 (SP2). ????? ??? ??????? ???? ????????? ?????? ???????? ???? ?? Windows Server 2008.

?????? ??? ??? ??????? ??? ?? ???? TCP/IP ???????? ?? Windows Server 2008 ?????????? ??????? ?? ?????? ?? ??? ?????? "???? ???? ????? ???????".

????? SNP ???? ??? ??? ???? ?????? ?? ???:
  • TCP Chimney Offload??? ??? ?????? ???????? TCP/IP ???????? ?? ???? ???????? ???????? ??? ???? ???? ????? ????? ??? ?????? ??????.
  • ????? ??? ???? ?????????? ??? ?????? ????? ?????? ?? ???? ???? ????? ??? ??????? ??? ?????? ????????? ?? ??????? ????? ?????????.
  • NetDMA??? ?????? ???? ????? ?????? ????? ????? ??? ??????? ???? ??? ?????? ?? ??? ?????? ?????? ?????? ??? ???? (DMA) ???? ????? ?????? ????? ??? ??????? ??? ??????.
???? ????? ??? ??? ????? ???? ????? SQL

?? ???? ????? ?? ???? ?? ????? ????? ??????? ??? ????? ???? ??????? ??? ?????? ?? ????? SNP.

?????? ?? ???? ????? ?? ???? ?? ????? ????? ??? ??? ???? ??? ?????? ???????:
  • ????????? ???? ?? ????? ?????? ???? ?????? ???? SQL Server.
  • ??? ??????? ????? SQL Server ???????? TCP/IP.
????? ????? 1

[Microsoft][?????? ????? ODBC SQL Server][DBNETLIB] ??? ?? ???? ??????? ??????. ???? ?? ??????? ?????? ???????

????? ????? 2

??? [08S01] ??? ??? ??????? [Microsoft] [???? SQL ??????]

????? ????? 3

System.Data.SqlClient.SqlException: ??? ??? ?? ????? ????? ????? ????? ????? ??? ??????. (??????: ???? TCP? ???: 0-????? ????? ?? ??? ????? ??????? ??????.)

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

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

???? ?????? ?????? ?????? TCP ?? ???? ???????? ???? ????? ?????? ??? ???? ??????? Enter:

????? tcp int Netsh ????????

????? ??? ????? ?? ???:

?? ??? ??????????? ??? ??????
2852159



???? ?????? ???? ??????? ???? ????? ??? ???? TCP Chimney Offload ????? ??? ???? ???????? ???? ????? ??????? ????? Enter:

Netsh int tcp ????? ????????????

????? ??? ????? ?? ???:

?? ??? ??????????? ??? ??????
2852160



?????? ???????? SNP ?? ???? ????? ???? ??????? ?? ????? SQL Server ???? ?? ???????

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

?????? 1: ??????? ???? ????? ??????? Windows Server

?? ??? ??????????? ??? ??????
????? ???? ???????????????
???? ??????? Windows ????? ?? Windows Server 2003 Service Pack 2
  1. ???? ?? ???? ??????? ?? ??? ???? ????????? ??????? ??????:
    • ????? ???? ???????/??????? ??????? ???? (BIOS) ??????
    • ??? ????? ??????? ??????? ?????? ????? ??????
    • ??? ????? ?????? ????? ???? ??????
  2. ????? ?????? ?????? ????????? ????? ????????? ?? ?????? ????????.

?????? 2: ??????? ???? ???????? Windows Server.

?? ??? ??????????? ??? ??????
????? ???? ???????????????
Windows Server 2003 Service Pack 2???? ?????? ????? SNP ?????? ??????? ?????? ?????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":
948496 ????? ?????? ????? SNP ? Windows Server 2003 ? Windows SBS 2003
??? ???? ?????? ??? ????? ???? ??? ???? ?? ??????? ??? ????? ???? ?? Windows Server ???? ?? ?????? ?? ????? ?????? ?? ???? TCP/IP. ??? ?? ???? ?????? ??????? ??? ????? ???? ???? ???? ?????? ???? ???? ???????? ???? ?????? ??????? ??????? ??? ???? ???????? ????????:
  1. ????? SNP ??? ?? ???? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":

    948496 ????? ?????? ????? SNP ? Windows Server 2003 ? Windows SBS 2003
  2. ????? ??????? ?????? ?????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":
    950224 ????? ???? ??????? ????? ???? ???? ????? ?????? (SNP) ? Windows Server 2003
  3. ????? ???? ??????. ???????? Regedit.exe

  4. HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
    EnableRSS = 1 (Dword)
Windows Server 2008
  1. ?? ?????? Windows Server 2008 Service Pack 2 (SP2). ????? ?? ????????? ??? ???? ??????? Windows Server 2008 SP2? ????? ??? ???? Microsoft ?????? ??? ?????:
    http://www.microsoft.com/en-us/download/details.aspx?id=16468
  2. ????? ??????? ?????? ?????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":
    979614 ??? ????? ?????? ????? TCP Chimney Offload ?? Windows Server 2008 ? Windows Vista
  3. ????? ??????? ?????? ?????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":
    967224 ??? ????? ??? ???????? TCP/IP ?? ??????? ??? ??? ??? ????? ??? ??????? ????? netsh ?????? ?????? ???????? TCP/IP ??? ???? ??????? ???? ?????? Windows Vista ?? Windows Server 2008
  4. ????? ????? ??? ???? ???? (RSS) ?? ???? ??????? ??????? ???? ???????. ????? ?? ????????? ??? ????? ????? RSS? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    967224 ??? ????? ??? ???????? TCP/IP ?? ??????? ??? ??? ??? ????? ??? ??????? ????? netsh ?????? ?????? ???????? TCP/IP ??? ???? ??????? ???? ?????? Windows Vista ?? Windows Server 2008
    ?????? ?????????? ??? ????? ???? ?????????? ?? Windows Server 2008.
Windows 7 ? Windows Server 2008 R2
  1. ????? ?????? 7 ? Windows Server 2008 R2 Service Pack 1 (SP1). ?????? ??? ??????? ??? ????? ?????? Windows 7 ? Windows Server 2008 R2 SP1? ????? ??? ???? Microsoft ?????? ??? ?????:
    http://www.microsoft.com/en-us/download/details.aspx?id=5842
  2. ????? ??????? ?????? ?????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":
    2775511 ???? ??????? ???? ????? ????? ??????? 7 SP1 ? Windows Server 2008 R2 SP1
    ?????? ??? ?? ??? ????? Windows 7 ?? Windows Server 2008 R2 SP1? ????? ????? ????????? ??????? ??????? ?? ???????? ??????? ?? "????? ??????? ? Microsoft":
    977977 RSS ??? ???? ????????? ?????? ??? ????? ????????? ???????? ??? ???? ??????? Windows Server 2008 R2 ???? ????? ??? ??????? ???? ?? 32
    979612 RSS ??? ???? ????????? ?????? ??? ????? ????????? ???????? ??? ???? ??????? Windows Server 2008 R2 ???? ????? ??? ??????? ???? ?? 32
    ??? ?? ????? ???? TCP Chimney Offload? ????? ??????? ?????? ?????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":

    2525390 ??? ????? ?????? ??? ????? ??? "true" ??? ??? ???? ???? ??????? ?? ????? ??? ????????? ???? ?? ????? ??????? ?? Windows 7 ?? ?? Windows Server 2008 R2
  3. ??? ??? ?? ??????? ????? ????? RSS ?? ???? ??????? ??????? ???? ???????. ????? ?? ????????? ??? ????? ????? RSS? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":

    967224 ??? ????? ??? ???????? TCP/IP ?? ??????? ??? ??? ??? ????? ??? ??????? ????? netsh ?????? ?????? ???????? TCP/IP ??? ???? ??????? ???? ?????? Windows Vista ?? Windows Server 2008

    ?????? ???? ???????? ??? ????? ???? TCP Chimney Offload ??? ??????. ???? ???? ?? ??????? ??? ??????? ???? ?????????. ????? ?? ???? ???? ???? ???????? ????????? ???? ??? ????????? ???????:
    • ?? ????? ??????? ??? ?????? 10 ?? ???? Ethernet (?????? ?? ???????) ???????.
    • ?????? ????? ?????? ????? ??? ?????? ??? ?? 20 ???? ?????.
    • ??? ????? ????? 130 ???? ???? ?? ???????? ??? ???????.


    ??????
    ???? ???????? ?? ????? ???? TCP Chimney Offload ????? ???????? ??????????.
?????? 8 ? Windows Server 2012?????? ?? ???? ?? ????? ??????. ???? ???????? ??????? ????????? ?????? ????? ????? ??????.

?????? ???? ???????? ??? ????? ???? TCP Chimney Offload ?? Windows Server 2012.

????? SNP/?????-???? ????? ???????

?? ???? ????? ????? SNP ??? ??????? ???? ?? Windows Server. ??? ???? ?? ???? ????? SNP ??? ????????? ??????? ??? Windows Server ????? ???????? ??????? ???????? ?? ???? ??? ???? ??? ??????? ????? ??????? RSS. ????? ?? ?????????? ???? ?????? ??????:

?? ??? ??????????? ??? ??????
????? Windows Server???? ?? ?????????
???? ??????? Windows Server 2003???? ??????? ??????? ?? "????? ??????? ? Microsoft":
948496 ????? ?????? ????? SNP ? Windows Server 2003 ? Windows SBS 2003
Windows Server 2008???? ??????? ??????? ?? "????? ??????? ? Microsoft":
951037 ??????? ??? ????? "TCP Chimney Offload ???? ????? ???? ??????? ?????? ??????? ???????" ?? Windows Server 2008
Windows Server 2008 R2?? ??? ??????
???? Windows 2012?? ??? ??????

?????? ???? ???????? ??????? ????????? ?????? ??????? ????? ?????? ?? ????? Windows Server 2012 ? Windows Server 2008 R2. ??? ???? ????? ????? ???? TCP Chimney Offload ??? ??? ???? ??? ?? ???? ????????? ?? ??? ??? ???? ???????? ???????? ??????? ??? ???? ????? ????? ?????? ?? ?????? ?????? ??.


?????

????? ?? ????????? ??? "???? ???? ????? ???????"? ????? ??? ???? WindowsITPro ?????? ??? ?????:
http://www.windowsitpro.com/article/networking/give-microsofts-scalable-networking-pack-140350

????? ?? ????????? ??? "????? ??? ???? ????"? ????? ??? ???? Microsoft TechNet ?????? ??? ?????:
????? ??????? ??? ???? ??????

????? ?? ????????? ??? ????? ??? ????? ????? ????? ??????? ????? ??? ???? TechNet ?????? ??? ?????:
??? ???? ???? ???????: ??? ????? ?????? ????? ??????

????? ?? ????????? ??? ????? ??????? ????? ?????? ?? ???? ??????? Windows Server 2008 R2? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
951037 ??????? ??? ????? "TCP Chimney Offload ???? ????? ???? ??????? ?????? ??????? ???????" ?? Windows Server 2008
????? ?? ????????? ??? ????? ??????? ?????? ?????? ???? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
2643970 ??????? ????? ???? ?????? ???????? (RSS? NetDMA ??????).

????? ?? ????????? ??? ????? ????? ???? ????? ????? ????? ??????? ????? ??? ???? Microsoft ?????? ??? ?????:

http://download.microsoft.com/download/8/E/D/8EDE21BC-0E3B-4E14-AAEA-9E2B03917A09/HSN_Deployment_Guide.doc
???? Microsoft ??????? ??? ??????? ?? ??? ?????? ???????? ?? ?????? ??? ????? ??????. ?? ????? ??????? ??? ??????? ??? ??? ?????. ?? ???? Microsoft ??? ??????? ??? ??????? ????? ????????.

???????

???? ???????: 942861 - ????? ??? ??????: 05/?? ?????/1434 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Parallel Data Warehouse
  • Microsoft SQL Server 2008 R2 Parallel Data Warehouse Update 1
  • Microsoft SQL Server 2008 R2 Reporting Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2012 Parallel Data Warehouse
????? ??????: 
kbsqlsetup kbexpertiseadvanced kbtshoot kbprb kbmt KB942861 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????942861

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

 

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