Privileges required to import an SQL Server Asset in Control Compliance Suite v11.0
|Article:TECH202340|||||Created: 2013-02-01|||||Updated: 2013-02-05|||||Article URL http://www.symantec.com/docs/TECH202340|
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 ).
Control Compliance Suite 11.x ; target SQL Server : MS SQL Server 2005 / 2008
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 .
- 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.
Article URL http://www.symantec.com/docs/TECH202340