Database Requirements

CA Virtual Assurance Release Notes › System Requirements › Manager Requirements › Software Requirements › Database Requirements

Database Requirements

CA Virtual Assurance uses Microsoft SQL Server as its database. Because CA Virtual Assurance integrates with other CA products, review the database requirements for integration products.

This release supports and is certified for the following versions:

2008 R2 (32 bit, 64 bit), Standard and Enterprise Editions, SP1 optional
2008 R2 Express (32 bit, 64 bit), Database with Management Tools, and Database with Advanced Services Editions, SP1 optional
2012 (32 bit, 64 bit), Standard and Enterprise Editions
2012 Express (32 bit, 64 bit), Database with Management Tools, and Database with Advanced Services Editions

SQL Server Tools (OSQL.EXE) are required on the manager system to connect to a local or remote SQL Server database.

Important! If you are upgrading an existing 12.6. 12.7, or 12.7.1 installation with SQL Server 2005 or SQL Server 2008, upgrade the SQL Server to a supported version. Then verify that the 12.6, 12.7, or 12.7.1 product is still operational and upgrade to CA Virtual Assurance Release 12.9.

Note the following:

For your convenience, SQL Server 2012 Express Edition (32 bit) is available on the CA Virtual Assurance installation media at the following location: DVD1\Installers\Windows\External\MSSQLExpress\SQLEXPRWT_x86_ENU.exe.
Named instances and SQL Server clusters are supported. Enable TCP/IP and use static port assignments for each instance. Dynamic ports are not supported.
The system that is installed with the manager components also must have the SQL client (server tools) installed.
After SQL Server Tools installation, verify that OSQL.EXE is installed properly to this location (if using the default install path):
- MS SQL 2012 C:\Program Files\Microsoft SQL Server\110\Tools\Binn

Remote Databases

If you are using a remote database, the local system must have an appropriate matching version of the SQL Server Native Client.

Examples

A remote 2008 R2, or R2 Express database requires a local 2008 R2 Native Client. A remote 2012 database requires a local 2012 Native Client.

The SQL Server Native Client is available from the Microsoft Download Center by searching, “Feature Pack for Microsoft SQL Server.” Based on your remote database and operating environment, complete these steps:

Select the most recent appropriate version.
Download and install the appropriate module for your operating environment on your local system.
Example: ENU\<x86 or x64>\sqlncli.msi