Has anyone tried doing an insert into the linked MySQL server from within a trigger?

An insert works fine if I execute it from the query window in SSMS but the...

Thanks for your reply. I applied the settings under the Distributed Transaction Coordinator section of your article but it is still the same, I'm logged in as a local Administrator...