SQL data collection fails with error: <No information available for this COM error> or The EXECUTE permission was denied

Products

• Control Compliance Suite
• Control Compliance Suite Standards Server

Issue/Introduction

Control Compliance Suite (CCS)

When running a SQL data collection on a CCS SQL asset, it comes back with the following error(s):

SQLAsset\servername: <No information available for this COM error>

and/or

The EXECUTE permission was denied on the object 'xp_msver', database '<database_name>', schema 'sys'
(NOTE: The error message above may vary as various permissions listed in the resolution below may be missing)

Environment

Release : CCS 12.5.X and CCS 12.6 SQL data collection

Component : Window user account that CCS uses to collect data on SQL assets

Resolution

The Window user that CCS uses to collect the SQL data does not have the required permissions to collect the data.

Make sure the Window users account (that CCS is configured to use for SQL import\data collection) has the following required permissions on that server and SQL instance:

• Make sure the user has the 'Log on as a batch job' permission (and is not in the Deny Log on as a batch job, as that will override the Log on as a batch job).
• That the user is in the 'Administrators' group on that server.
• Make sure user has read rights by assigning it the SQL permission db_datareader role on all databases on the server.
• Also make sure the user has all the sql permissions on Master as listed in the table below:

Dependent Tables (T)/Stored Procedure (SP) in SQL Server	Master/Current Database	Rights on the dependent database object
sp_Msdbuserpriv	Master	Execute
sp_MSdbuseraccess	Master	Execute
sysprocesses	Master	Select
sysusers	Master	Select
syslogins	Master	Select
xp_regread	Master	Execute
sysdevices	Master	Select
sysconfigures	Master	Select
syscurconfigs	Master	Select
syslanguages	Master	Select
sysservers	Master	Select
fn_helpcollations	Master	Select
xp_msver	Master	Execute
sp_helpsort	Master	Execute
xp_instance_regenumvalues	Master	Execute
xp_instance_regread	Master	Execute
sp_server_info	Master	Execute
xp_loginconfig	Master	Execute
sp_helpsrvrole	Master	Execute
xp_servicecontrol	Master	Execute