Tried these suggestions:
Set sharing on the Temp directory to everyone/full control. (relocated the Temp directory to root of C:/ instead of Docs and Settings)
Went to Component Services, 'My Computer' the one that has a MS DTC tab on it. Set the access to Allow Outbound, Allow Inbound, (Mutual Authentication Required), Allow Remote Clients, and Allow Remote Administration (all checked)
Unchecked: Enable Transaction Internet Protocol (TIP) Transactions
Unchecked: Enable XA Transactions
MS Office is installed on the computer hosting the server. (my computer)
Still get the same error message.
??This is possible to do, right....set up a Server on a WinXP destop CPU that is networked on my company's server?? It's just the linked server's that aren't working, and those are elsewhere on the Company's server domain.