?? ???? ????? ??? 7391 ?? SQL Server 2000 ??? ????? ?????? ???????? ????? ???? ????? ??? ????? Windows Server 2003 ?? Windows XP Service Pack 2

?????? ????????? ?????? ?????????
???? ???????: 839279 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ?????? ???????? ????? ???? SQL Server "? ?? ????? ????? ??? ?????? ??????? ???????:

????: ????? 7391 ? ????? 16 ???? 1? ????? 1
???? ????? ??????? ??? ???? OLE DB 'SQLOLEDB' ????? ??? ??? ?????? ????????. [???? OLE DB/????? ???????: ????? ????? ???????? ???? ???? ????????? ??????.] ???? ????? OLE DB [???? OLE DB / 'SQLOLEDB' ????? ITransactionJoin::JoinTransaction 0x8004d00a].


?? ???? ??? ??????? ??? ???? ??? ?????? ???????:
  • ?? ????? ???? ??????? Windows Server 2003 ?? Microsoft Windows XP Service Pack 2 (SP2) ??? ????????? ???? ???? ???? ?????? ?????.
  • ?? ????? ???? ??????? Windows Server 2003 ?? Microsoft Windows XP SP2 ??? ??????? ???? ???? ?????? Microsoft SQL Server 2000 ?? ??? ??? ????????? ??? ???? ????????? ???? ???? ???? ?????? ?????.

?????

???? ??? ??????? ???? ???? ?? ???? ?? ??????? ???????:
  • ???? ????????? ??????? Microsoft ????? (MSDTC) ?? ??????? ???? ???????.
  • ??? ????? ???? ????? Windows ??? ?????????. ???? ???????? ???? ???? ????? Windows ???? ????????? ??????? Microsoft ???????? ???? (MSDTC).

    ?????? ?? ???? ??? ??????? ??? ????? Windows ????? ????? ???? ?????.

???? ??????

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322756????? ??? ???? ???????? ? ??????? ??????? ?? Windows


??????? ?????? ??? ??? ??????? ???? ??????? ??????? ??? ???? ????????? ???? ?? ????? Windows Server 2003 ?? Windows XP SP2 ???:
  1. ???? ?? ?? ???? ????? ?????? ?? ???? MSDTC ??? ???? ???? ??????. ?????? ????? ???? ??????? ???????:
    1. ???? ??? ???? ?? ???? ??? ?????.
    2. ?? ???? ?????? ????? ???? Services.msc ??? ?? ???? ??? ?????.
    3. ?? ?????? "???????" ? ??? ???? ???? ???? ????????? ??????? ??? ??? ?? ????? ??????.
    4. ??? ?????? ????? ?????? ?? ? ???? ?? ??? ??? ???? ????? ?????? ?????? ?????? "??" ?????? ??????.

      ??? ??? ???? ????? ?????? ?? "???? ??????, ????? ??? ?????? 2. ??? ??? ???? ????? ?????? ?? ???? ?????? ??????, ?????? ??? ???????.
    5. ???? ??? ???? ?? ???? ??? ?????.
    6. ?? ???? ?????? ????? ???? cmd ?? ???? ??? ?????.
    7. ?? ???? ???????? ???? msdtc Net stop ?????? ???? MSDTC.
    8. ?? ???? ???????? ???? Msdtc ?uninstall ?????? MSDTC.
    9. ?? ???? ???????? ???? regedit ???? ???? ???????.
    10. ?? "???? ???????" ? ??? ???? ??????? ??????:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
      ????? ???????.

      ??? ??? ???????.
    11. ?? ?????? "???? ???????".
    12. ?? ???? ???????? ???? Msdtc ?install ?????? MSDTC.
    13. ?? ???? ???????? ???? Net start msdtc ???? ????? ???? MSDTC.

      ???? ??? ??? ????? ???? ????? ?????? ?? ???? MSDTC ??? ???? ?????? ??????.
  2. ????? MSDTC ?????? ??????? ???? ???????. ?????? ????? ???? ??????? ???????:
    1. ???? ??? ???? ?? ???? ??? ?????.
    2. ?? ???? ?????? ????? ???? dcomcnfg.exe ??? ?? ???? ??? ?????.
    3. ?? ?????? "????? ????????" ? ????? ????? ???????? ????? Computers ?? ?? ?????? ???? ?????????.
    4. ???? ??? ?????? ?????? ??? ???? ????????? ?? ???? ??? ?????.
    5. ?? ???? ?????? ????? ???? ????????? ? ???? ??? ????? ?????? ??? ????? ??????? MSDTC.
    6. ?? ???? ?????? "????? ??????" ? ???? ?????? ???? ???????? ???? DTC ??????.
    7. ?????? ????????? ??????? ???? ??????? ??? ??? ????????? ?? ??????? ????, ???? ?????? ???? ???????? ?????? ???????.
    8. ?????? ????????? ??????? ???? ??????? ??? ??????? ???? ?? ??? ?????????, ???? ?????? ??????? ?????? ???? ????????.
    9. ??? ?????? "????? ????? ?????????" ? ???? ?????? ?????? ????? ?????? ??. ????? ????? ?????? ?? ??? ?? ?? ?????? ??????? ???????.
    10. ?? ???? ?????? "????? ??????" ? ???? ??? "?????".
    11. ?? ???? ?????? ????? ???? ????????? ? ???? ??? "?????".
  3. ????? ???? ????? Windows ?????? ???????? MSDTC ?? ?????? ?????? ??? ?? ???????. ?????? ????? ???? ??????? ???????:
    1. ???? ??? ???? ?? ???? ??? ?????.
    2. ?? ???? ?????? ????? ???? Firewall.cpl ??? ?? ???? ??? ?????
    3. ?? ???? ?????? ? ???? ????? ??????? ??? ???? ????? Windows.
    4. ?? ???? ?????? "???? ????? Windows" ? ???? ??? ????? ?????? ?? ????? ??????? ?????????.
    5. ?? ???? ?????? ????? ?????? ? ???? ??? ???? ??????? ??? ?? ???? ???? ????? Msdtc.exe. ???? ???????? ??? ????? ????? ?? < ???? ????? ??????? >: \Windows\System32 ??????.
    6. ?? ???? ?????? ????? ?????? ? ???? ??? "?????".
    7. ?? ???? ?????? "???? ????? Windows" ? ???? ?????? ?????? msdtc ?? ??????? ??????? ????????.
    8. ???? ??? "????? ????" ?? ????? ??????? ?????????.
    9. ?? ???? ?????? ????? ???? ???? 135 ?? ???? ???? ??? ?????? ?? ???? ??? ????? ???? TCP.
    10. ?? ???? ?????? ????? ???? ? ???? ????? ????????? ?? ???? ???? ????? ?? ???? ??? ?????.
    11. ?? ???? ?????? "???? ????? Windows" ? ??? ??? ????????? ?? ????????? ?? ?????? j ?? ??????? ??????? ???????? ?? ???? ??? ?????.
  4. ?????? ????? ????? ping ???? ?? ???? ?????? ??? ?????? ?????? ??? ?????? ?????? ??? ?????? ?????? ???????? ??? netbios (??? ??????, ??? ??????). ?????? "???? ????????? ??????? ?? Microsoft" ??? netbios ??? ??? ?????? ?????? ??????? ?????? ???? ??????. ?? ???? ??? ????? ????? ????? ????????? ???????. ?? ???? ??? ????? ping ???????? ??? netbios ??????? ??? ????? ????? ??????? ???????:
    172218????? ????? ??? ?????? TCP/IP Microsoft

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

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

  1. ?? ?????? ?????? ??? ????? ??????? ???? ????? ??? Windows Server 2003 ?? Windows XP SP2 ?????.
  2. ????? ???? ???????.
  3. ????? ??????? ???? ???? ????? Microsoft SQL Server 2000 ????? ??????. ?????? ????? ?? ?????? ????? SQL ???????? ??????? ?? Query ????:
    EXEC sp_addlinkedserver  '<remote_server>',  N'SQL SERVER'
    GO

    ?????? ??????? remote_server ??? ????????? ???? ??? ?? ??? ????? ??? ???? ???? ?????.
  4. ????? ??????? ????? ??? ??? ????????? ????????? ??????. ?????? ????? ?? ?????? ????? SQL ???????? ??????? ?? "??????? ????":
    SET xact_abort ON 
    GO
    USE  pubs
    GO
    BEGIN DISTRIBUTED TRANSACTION
    SELECT  *  FROM <remote_server>.pubs.dbo.authors
    COMMIT TRAN
    GO
    
    ?? ????? ????? ????? ???????? ?? ??? "???????".

?????

?????? ??? ???? ?? ????????? ??? ????? Windows XP Service Pack 2 ????????? ?? SQL Server 2000 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
841249????? ????? Windows XP Service Pack 2 ????????? ?? SQL Server

???????

???? ???????: 839279 - ????? ??? ??????: 04/?????/1430 - ??????: 4.0
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft Windows XP Embedded
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
  • Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
  • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
????? ??????: 
kbmt kbregistry kberrmsg kbdtc kbdomain kbauthentication kbtransaction kbrpc kbprb KB839279 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????839279

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

 

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