????? DTC ??? ?????? ??? ????????? ???? ?????? Windows Server 2003 SQL HOWTO:

?????? ????????? ?????? ?????????
???? ???????: 555017 - ??? ???????? ???? ????? ????? ??? ???????.
Author: Robert McLaws MVP
????? ???? | ?? ????

??????? ????

????? Windows Server 2003 ??????? ?? ??????? DTC ??? ????? ??? ?????? ??? ?? ????? ????? several-??? ????? ??????? ?? ??? ????? ?????? ??? ?? ??? ???????. ????? ???? ?? ???? ????? ???? ???????? ?????? ??????? ??? ?????? ????? ??? ?????????.
 
?????: DO NOT ?????? ??? ??????? ???? COM + ?????? ??? ??????. ??? ??? ?????? ?????? ???????? COM + ??? ?? ???? ??? ??? ???? ??????, ????? ??????? ????? COM + ??? ??? ??????? crippling ??????? Windows ??????? ???. ??? ??? ???? ????? ?????? ?? ?? ??? ????? ?????? ?????? ?????? ????? Windows Server 2003.
 
????? ?????? ????: ??? ????? ?????? DTC ???? ??????? (????? ??? ???? ??????? ???? ????? ???? DTC)
   1. ???? ??? ???? ?? ??? ??? " ???? ?????? , ????? " ????? ?? ????? ??????? .
   ???? ??? 2. ????? / ????? ?????? Windows .
   ??? 3. Application Server , ??? ?? ???? ??? ?????? .
   4. ??? ????? ???? DTC ?????? , ??? ?? ???? ??? ????? .
   ???? ??? 5. ?????? .
   6. ???? ??? ????? .
   ????? 7. ?? ?? ??? ????? ?????? Distributed Transaction Coordinator.
   ????? 8. ??? ?? ??? ????? ??? ????? ????? ???? ????? ?? ???????? ??????? (??? Microsoft SQL Server ?? Microsoft ????? Queue Server).
 
?????? ??? ???? ?? ????????? ??? ??? ??????? ???? MSKB 817064
 
?????? ??????: ????? SQL Server 2000 ???? Tools ??? ???? ??????? ???? ????? ???? DTC.
???? ?????? ??? ????? ???? SQL ??? ????? ??????? SQL Server 2000. ????? ???????? ???? ?? ????? ???? MS DTC.
 
?????? ??????: ????? VPN ?????? (OPTIONAL)
??? ???? ????? ????????? ????? ????? ?? ???? ??????? IP ? ???? ?? ???? ??? ??????. ???? ???? ??? ???? ???? ?????? ??? ???? ????? ???????? ???? ???? ?????? ?????? ???? ???????? ??? ??? ?????? ?????.
   ????? ????: ????? ???? VPN
      1. ???? ??? ???? ?? ??? ??? " ???? ?????? , ????? ??????? ???? ??????? .
      ???? ??? 2. ????? ????? ???? .
      3. ??? ????? ????? ????? ??? ?? ???? ??? ?????? .
       ???? ????????? ???????? ??? 4. ??? ?? ???? ??? ?????? .
       ?? ??? ????? ???? ???? ??? ?? ???? ??? ??????.
      6. ??? ?????? ?????????? ?????? ???????? ??? ?? ???? ??? ?????? .
      ??? 7. ?? ???? ?????? ???? ??? ?????? ??? ?? ???? ??? ?????? .
      ????? 8. VPN ???? ?????? ??????? ?? ????? ???? IP ?????? ???? ??????? ??????.
      ???? ?? 9. ?????, ?? ?????? ???????? ??????? ??? ???? ??????? ??????? ??? ?? ???? ??? ?????? .
      ???? ??? 10. ????? ?????? ???? VPN.
   ??? ??????: ????? ????? VPN
      1. ???? ??? ???? ?? ??? ??? " ???? ?????? , ????? ??????? ???? ??????? .
      ???? ??? 2. ????? ????? ???? .
      3. ??? ??????? ????? ??????? ?? ???? ????? ??? ?? ???? ??? ?????? .
      ??? 4. ????? ???? ???? ?????? ??? ?? ???? ??? ?????? .
      ???? 5. ?? ??? ?? ??? ??????? ?? ???? ??? ?? ???? ??? ?????? .
      6. ??? ??? ??? ????? ???? ??? ?? ???? ??? ??????.
      ???? 7. ?? ????? IP ????? ???? VPN, ??? ?? ???? ??? ??????.
      ??? ???????? 8. ??? ?? ???? ??? ??????.
      ???? 9. ???? ???????? ????? ?????? ??? ??? ??????? ??? ??? ?????? ??? ?? ???? ??? ????? .
 
????? ?? ??? ???????? ???? ???? ??????? ????? ??????? ?????? ??? ?? ???? ?????? Internet Connection ????? (ICF) ? ??? ??????? ???? ???? ??? ????? VPN ????.
 
?????? ??????: ????? NETBIOS ??? ???? ???????
?????? ?? ???? ????? ????? ??????? ?? ??? HOSTS (c:\windows\system32\drivers\etc) ???? ??????? ?? ???? pinged ??? ??? ??????. ???? ????????? ?? ??? HOSTS ?????? ??? ???? ?? ????????? ??? ????? ????? ???.
 
?????? Five: ????? ???? RPC ?? ??? ???? MS DTC ??? SQL Server
??? ?????? ????? ?????? ??? ??????? ????????. ??? ?? ??? ??? ????, ????? ???????? ????? ???? ???????? ??????? ?? ??? ?????.
   1. ???? ??? ???? ???? ??? ????? , ????? ?? " Regedt32 " ? ?? ???? ??? ????? .
   ??? 2. HKEY_LOCAL_MACHINE , ?? " ??????? " ? ?? Microsoft .
   ???? ??? ?????? ?????? ??? ??? MSDTC 3., ??? ??? ????? , ?? ??? ???? DWORD .
   ????? ????? ??????? ?? ????????? ???? ????? # 1 ??? TurnOffRpcSecurity 4..
   ???? ????? ??????? ??? ??????? ?????? 5. ??? ?????? ?????? ??? 1 .
   6. ???? ???? ??????? ?? ??? ????? ???? SQL
 
?????? ??? ???? ?? ????????? ??? ??? ??????? ???? MSKB 827805
 
????? ????? VPN To ???????? ??? ??? ??????? ?? ??????? ?? VPN (OPTIONAL) ? ?????? Six:
???? ??????? ??????? ??? ?? ???? ???? VPN:
   ??? ????? VPN 1. ???? ????? .
   ?? ?????? ????? ???? ???????? ?????? ?? ??? ? ???? ????, ???????, ???. 2. ??? ????? ??????? ?????? .
   3. ?? ??????? ???? , ????? ?????? Internet Protocol (TCP/IP) ? ?? ???? ??? ????? .
   4. ?? ???? ?????? ????? TCP/IP ?????? ???? ??? ?????? ?????? " ? ??? ?????? ????? ???? ???????? ??????? ???????? ?????????? ??? ???? ??????? ??????? .
   5. ???? ???? ?? ???? ?????? ?????? ??? ?????.
   ??????? ??????? ??? ???????? ????? ?????? (?? ?????? 3 ?? ????? 1 ?? 7 ????), 6. ?? ???? ?? ?????? ???? ?? .
   ???? ?????? Windows? ?? 7. ?? ????? ??? ?????? And Users\????? Settings\All ????\???????\??? ??????? C:\Documents .
   ???? ???????? VPN ???? ?????? ?? ?????? ?????? 8 ??????? ?? ??? ?????? ??? ???? ??? ??????? ?? Windows Explorer ? ????? 2 ? 8..
   9.Shut ???????? ?? ??? ????? ??????.
 
?????? ??????? ????. ???? ???? ??? ????? SQL ??? ?? ???? ?????? ??? ???????? ?? ????????? ??????? ????.
 
??? ??? ??? ORCSWeb ?????? ??? ???????? ?? ????? ??? ???????.

???????

???? ???????: 555017 - ????? ??? ??????: 24/????/1424 - ??????: 1.0
????? ???
  • Microsoft Windows Server 2003, Standard Edition
  • Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems
  • Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems
  • Microsoft Windows Server 2003, Datacenter Edition
  • Microsoft Windows Server 2003, Enterprise Edition
  • Microsoft Windows Server 2003, Web Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbpubtypecca kbpubmvp kbhowto KB555017 KbMtar kbmt
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????. ??? ?? ???? ??? ??????? ????? ?? ???????? ?? ??? ???????? ?????? ????? ????????? ??????? ???? ??? ???????
???? ??? ????? ??????? ?????? ??????????555017
COMMUNITY SOLUTIONS CONTENT DISCLAIMER
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.

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

 

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