bv-Control for Microsoft SQL Server requirements

book

Article ID: 179572

calendar_today

Updated On:

Products

Control Compliance Suite Windows

Issue/Introduction

 

Resolution

bv-Control for Microsoft SQL Server requirements

The RMS data collector uses the bv-Control for Microsoft SQL Server snap-in module to collect data from Microsoft SQL Server databases. Before you install bv-Control for Microsoft SQL Server, ensure that your workstation and SQL Server environment meet the minimum requirements to run the product.

In addition to the general system requirements for the Information Server, your Information Server should have a minimum of 1 GB RAM.

bv-Control for Microsoft SQL Server can query and report on various versions of the Microsoft SQL Server.

The bv-Control for Microsoft SQL Server snap-in supports the following Microsoft SQL Server platforms:

  • Microsoft SQL Server Desktop Edition 1.0 and 2000

  • Microsoft SQL Server Standard Edition 7.0, 2000, and 2005

  • Microsoft SQL Server Personal Edition 2000

  • Microsoft SQL Server Enterprise Edition 7.0, 2000, and 2005

  • Microsoft SQL Server Developer Edition 2000 and 2005

  • Microsoft SQL Server Workgroup Edition 2005

  • Microsoft SQL Server Express Edition 2005 (the auditing feature is not supported)

Note:
To query against Microsoft SQL Server 2005, you must install the SQL Distributed Management Object component, SQLDMO.dll, on the Information Server. You can install the component either separately or from the CCS_DataCollection\Redist folder on the product disc.

Certain minimum rights are required for querying against the data sources. You specify the credentials that meet these minimum rights in the Credentials Database.

The following minimum user rights are required to query the SQL Server:

  • The user credentials for Windows or SQL Server that are supplied for connecting to the SQL Server must be a user for the SQL Server. Otherwise, the credential verification in bv-Control for Microsoft SQL Server fails.

  • User credentials for Windows or SQL Server that are supplied for connecting to the SQL Server must have read rights on the master database. This master database must belong to the SQL Server that is queried. Otherwise, the credential verification in bv-Control for Microsoft SQL Server fails.

  • For a query on a particular database on the SQL Server, the read rights are required on that database.

The product supports queries for the target SQL Servers in an untrusted domain.

You should use SSL to encrypt application traffic between the Information Server and the target SQL Server. The bv-Control for Microsoft SQL Server functionality does not require SSL communication to be enabled. The product works seamlessly with the encrypted or non-encrypted protocols to communicate with the SQL Server. The communications preferences are set in the SQL Server client configuration. You should also ensure that your SQL Server is patched appropriately and regularly for any vulnerabilities that are related to the open SQL port.

When you use SQL audits, you may configure bv-Control for SQL Server to collect only the required information. SQL audits can generate large data sets. The large data sets can have an impact on the disk space requirement or the network bandwidth requirements. In addition, the amount of data might degrade SQL Server performance.