SQL Server asset import fails if user credentials does not have local administrator right on the target SQL Server.
The operation completed successfully ( error encountered after completion of a SQL asset import job , and the data collector doesn’t return any assets to the CCS ).
Lack of local administrator privilege to the Windows user credential of target SQL Server as defined in the credential database of the CCS 11.0 .
Note : The above mentioned requirement is only if using ‘Agentless’ method to configure the target SQL Server in the CCS v11.0 system .
Applies To
Control Compliance Suite 11.x ; target SQL Server : MS SQL Server 2005 / 2008