I'm nearing my wits' end on this one. I've got two SQL Server 2000 instances (both SP 3a) each running on its own Windows Server 2003 R2 virtual machine, call them SQLA and SQLB. I've got SQLA set up as a linked server on SQLB. I've got a SQL login on SQLA dedicated to this linked server setup, I've configured the linked server to use that user's security context for unmapped logins, and have no login mappings defined.
I'm developing a stored procedure on SQLB which queries some tables in MSDB. I've verified that, from SQLB, I can select from all the tables involved in the stored procedure (with a simple SELECT * FROM SQLA.msdb.dbo.[table]).
When I try to execute the stored procedure, however, I get the following error:
Things I've tried, without success:
All the recommendations in KBA 839279 - I've ensured MSDTC is running on both machines as Network Service. I've checked the security configuration for MSDTC on both machines, and confirmed that Network DTC access, Allow Inbound, Allow Outbound, and No Authentication Required are selected. I've confirmed that Windows Firewall isn't running on either machine. No dice on all fronts.
Any thoughts, input, advice, avenues of exploration, etc, very appreciated. Thanks!