Re: COM+ Transaction problem
Under Win2k3 try this:
(i) Go to component services\Computers
(ii) Right click on My Computer to get Properties
(iii) Go to the MSDTC tab
(iv) Make sure Network transactions are ticked (I tick all the boxes, actually)
Let me know if it works.
Re: COM+ Transaction problem
I suppose I should offer an explanation . . .
When you mark a component as 'Required' or similar every method call will enlist any applicable providers into a transaction. So if you have a SQL Server referenced in a function call (highly likely) that SQL Server will be enlisted, as will the file system, and the source-code itself.
Win2k3, by default, prevents MSDTC from enlisting providers across the network - for obvious reasons I won't go into here - but the basic premise is that MS-RPC (which MSDTC is derived from) is not a very secure subsystem, so MS lock it down by default.
What I suggested to you is to navigate to the tickbox that allows you to override the defauly MS settings regardin enlisting providers across the network.