How to Configure Control Compliance Suite BV-Control for Windows to Collect Data from Sharepoint 2007
Last Updated July 29, 2011
The following provides information on the privileges and steps required to configure data collection from SharePoint.
Note: 2011-2 PCU or greater must be installed to collect data from Sharepoint.
The privileges that you require to collect data from SharePoint are as follows:
｡On a distributed environment where the SharePoint and SQL database are installed on separate computers, install the Query Engine (QE) on the same computer where the SharePoint Application server is installed.
In case, the SharePoint and the SQL database are installed on the same computer, then do not install additional QE on the SharePoint server. The QE that is present on any other computer in the domain can collect data from SharePoint server.
｡The user account in which the QE service is running must be a domain user account having local administrator or equivalent permissions and it must exist in the SQL database that is configured with SharePoint. If the QE service user account does not exist in SQL Server, then create a new login for the QE user and ensure that the QE user account has the read access to the SharePoint databases.
Verifying user permissions on SharePoint databases
This section gives information on the steps you must follow to configure the permissions that are required for data collection on SharePoint databases.
If the Accessdenied or Notaccessible errors are displayed, ensure that QE service user has been assigned correct permissions on the SharePoint databases.
To confirm the permissions
1 In the Microsoft SQL Server Management Studio, do the following:
｡Connect to the database engine hosting SharePoint databases.
｡Go to Security > Logins.
｡Right-click the QE user name and select Properties.
2 In the Login Properties pane, select User Mapping.
3 In the Users mapped to the login grid, select the check boxes for the SharePoint related database.
The QE user must have Public, db_datareader, and WSS_Content_application_Pools roles on the SharePoint configuration and SharePoint Central Administration Content databases. In a default installation, the SharePoint configuration database name is SharePoint_Config and the SharePoint Central Administration Content database name is SharePoint_AdminContent_<GUID Value>.