CB Protection: How to delete an invalid certificate stuck in a validation loop

[#1]

Environment

• CB Protection Server: 8.1 Patch 2 and Higher
• Microsoft SQL Server: All Supported Versions

Objective

How to delete an invalid certificate stuck in a validation loop. 

Resolution

1. Open SQL Management Studio
2. Run the following SQL script with the Certificate ID specified. 

   use das;
   exec dbo.DeleteINvalidCertificateBinary <ID>

Additional Notes

Please do not run the script above unless requested by Carbon Black Technical Support