SQL Server data collection job is failing with "The job cannot be completed because Windows credentials are not configured" in CCS
Article ID: 280288
Updated On:
Products
Issue/Introduction
When running a data collection job or CER job in Control Compliance Suite, the following error is seen.
The job cannot be completed because Windows credentials are not configured. Windows credentials are required for data collection from the SQL Configuration Data Source entity. Configure the credentials in Settings > Credentials, and then run the job.
Cause
Windows credentials exist but are setup to be asset-based credentials vs common credentials.
The SQL Server asset was created either manually or imported via CSV initially before any network asset import jobs were run on the already imported asset.
This asset does not align 100% with the existing Windows machine asset. So when CCS looks for a Windows machine asset, it does not find it, so throws the error that no Windows credentials are configured.
Resolution
Make sure that the SQL Server asset matches with the existing Windows machine asset.
If needed delete the current SQL Server machine asset, do a fresh asset import job using "Network" as the "Source", then for scope select the Windows machine asset that has the SQL Server installed.
Once the SQL Server has been imported, re-run the data collection/CER job on the SQL Server asset. Data collection will now succeed.
Feedback
