Monday, April 05, 2010

SQL Distributed Transaction fired by a COM+ not working

If you have some COM+ object that connects to SQL Server and opens a transaction, sometimes it stops working at all, you may be facing a COM+ Corrupted Database, to “repair” this database you must follow the following steps:


  1. Find the file %WinDir%\System32\Clbcatq.dll and rename it to ~Clbcatq.dll
  2. Reboot the computer in Recovery Mode.
  3. Open the Registry and delete the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\COM3.
  4. Find in the %WinDir% directory and look for a subdirectory named Registration. Delete Registration folder.
  5. Reboot the machine normally.
  6. Open Control Panel | Add/Remove Programs | Add/Remove Windows Components.
  7. Click Next to reinstall COM+.
  8. Now your transactions should work




Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server Tags: SQL Server

Note: Cross posted from Eduardo Castro.


No comments:

PASS Marathon Spanish Edition Azure SQL Datawarehouse

Este 21 de febrero estaré participando como conferencista en el PASS Marathon Spanish Edition, el registro al evento está en el siguiente en...