CORA Cleanup does not work with SQL Server 2008

Document ID : KB000022377
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

CORA Cleanup does not work with SQL Server.

 

Environment:  

CA Client Automation – All Versions

 

Resolution:

IMPORTANT: This article contains information about modifying the registry.

Before you modify the registry, make sure to create a back up of the registry and ensure that you understand how to restore the registry if a problem may occur.

For information about how to back up, restore, and edit the registry, please review the relevant Microsoft Knowledge Base articles on support.microsoft.com.

For SQL Server 2008, for CORA cleanup to connect to the database the DWORD key 'UseIPv4ForDB' needs to be set to 1 under:
'HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ComputerAssociates\Unicenter ITRM'.

 

If the key does not exist it needs to be created. After running coracleanup this key needs to be reset to 0.