ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Privileges required to import an SQL Server Asset in Control Compliance Suite v11.0
Article ID: 157633
Updated On:
Products
Control Compliance Suite Databases MS SQL SRVR
Issue/Introduction
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 ).
Cause
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 .
Resolution
- In order to import a SQL Server asset into CCS v11.0 , the Windows user credential used to connect to the target SQL Server should have the local administrator rights on the SQL Server machine . Otherwise , the SQL Server asset does not get imported .
Note : The above mentioned requirement is only if using ‘Agentless’ method to configure the target SQL Server in the CCS v11.0 system .
- Please refer to page 18 topic : ‘Privileges to import an SQL Server Asset’ in the attached document named : ‘CCS_Data_Collection_Privileges.pdf’ for detailed information.
Applies To
Control Compliance Suite 11.x ; target SQL Server : MS SQL Server 2005 / 2008
Attachments
Feedback
Yes
No
Powered by
