Any Distributed Data failure RRS feed

  • Question

  • Scenario:
    I have one windows server 2003 and 2 windows XP clients on one machine by virtual pc.
    All pings to each other.
    The 2 windows XP clients are joining a domain in the server.
    They have administrator accounts and administrative privilages on each other.

    On each windows there is SQL2000 with SP3 using windows authentication.
    Each MSSQLServer and other SQL Services log in by the administrator domain account and has the domain account of the other windows in sysadmin role.

    Both XP SQL Servers are linked to each other.

    MSDTC is running on all servers with allowing every available option by Services Components.

    Firewalls are off in all servers.

    Although, neither distributed transactions work giving this error:
    "Server: Msg 7391, Level 16, State 1, Line 7
    The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."

    Also Snapshot agent in replication cannot start.

    My Question is: Is there something to do with RPC and how?
    Please help...

    Sunday, July 2, 2006 8:29 PM


  • I found the answer in:

    Monday, July 3, 2006 5:23 PM