SQL Server Logon Trigger causing problems with the Distributed Transaction Coordinator
If you dig through the discussion in the articles comments, you'll find a link to KB951188 which details a bug in SP2 that was fixed in CU7. Check your version level to see if it applies.