Are you connecting to the local server using Windows authentication? If so, it'll attempt a Windows authentication connection to the other server. In that case, port 135 (and some others)...

What does the error log for SQL Server indicate? Anything in the system or application event logs? Usually if they're boucing there'd be something in the Windows logs as to...

It may be. How are you connecting to the SQL Server, Windows authentication or SQL Server login? How is the linked server connection specified to connect?

This is the one I usually refer to since it also lists version changes due to hotfixes:

SQL Security: SQL Server Version Database

This depends... if you are capturing the new values, you want inserted. If you are capturing the old values, you use deleted.

There are a few causes to this but the most likely is MS DTC isn't running on one of the two SQL Servers. Can you verify that they are? Also,...

Where you have FOR INSERT change to FOR UPDATE. The inserted table is present with UPDATE triggers. It represents the new values for the rows changing. The deleted table is...

It sounds like the SQL Server is set up to only allow Windows authentication. In order to be able to use a SQL Server login, the SQL Server will need...

I know we implemented an earlier version of the tool (pre-OLAP support) and it was inexpensive and works well for us. We also use their reporting piece. Last I remembered,...

No, it does support the OLAP connections. An example walkthrough that demonstrates this with an MDX query is here:

DynamiCube 3.0 Help: Using MDX

The issues with DTC on XP/2003 was because MS changed how DTC worked. The network DTC access/COM+ Rollup package addresses those issues. If it's a DTC issue between two Windows...

Availability of Windows XP COM+ Hotfix Rollup Package 10

This looks to be the latest, although you might have to check with MS to find out. We...

The one I know about that is similar is Data Dynamics' DynamiCube. We looked at it once upon a time. It's $599, but unfortunately it is an ActiveX control. Still...

Yes. If that one server has bad memory or a bad motherboard, it would have the issue you described while the others would be fine. We have seen occasions where...

To piggy-back on Chris, we've seen this with several different issues:

a) bad motherboard

b) bad memory

c) bad driver for a piece of hardware