"Failed to reconcile the asset :example\user1. Reason: The following primary field is missing: Domain/Workgroup Name." in CCS

Products

• Control Compliance Suite Standards Database
• Control Compliance Suite
• Control Compliance Suite Standards Server

Issue/Introduction

When running an agentless SQL asset import job you are seeing the following error in Control Compliance Suite.

Failed to reconcile the asset : example\user1. Reason: The following primary field is missing:

Domain/Workgroup Name.

When looking at the DBIF.SERVER_*ReplyXML.xml file you see an error like this.

<message level="2"><desc><![CDATA[Caught _com_error in ADOSQLConnection::GetSQLServerHostName : hr = -2146824579 : Message: Unknown error 0x800A0E7D]]></desc></message>

Cause

In this specific case, the SQL Server named instance had the SQL Browser service disabled, and the SQL Server had been modified to listen on the default port of 1433.

Resolution

With the SQL Browser service disabled and the named instance listening on the default port 1433, the SQL client was not able to properly connect.

Once you specify the port <Server1\NamedInstance,1433> then the connection is successful.
CCS was detecting the default port, and since it is the default port was not including that in the connection string.

A private fix was released for this issue, if you run into this issue contact support for the fix.
This fix will be included in the upcoming 12.7 release in 2024.