Installation Guide › Installing CA Virtual Assurance › Installation Requirements and Considerations › Verify Requirements for Using SQL Server

Verify Requirements for Using SQL Server

CA Virtual Assurance requires SQL Server for Management Database and Performance Database. CA Virtual Assurance provides the following SQL Server support:

• Local or remote SQL Server
• Default SQL Server instance or named instances
• Static SQL Server TCP/IP port
• Windows authentication and SQL Server authentication

Follow these steps:

1. Verify SQL Server requirements
   • Verify that TCP/IP is enabled.
   • Verify that a static TCP/IP port is specified for the instance that you plan to use. Dynamic ports are not supported.
   • Verify that there is no IP address used as the server name for the local database.
   • Verify that Remote Connections are enabled if you want to connect from a remote computer.
   • Verify that the authentication mode that you require is specified (Mixed Mode or Windows authentication).
   • Verify that the instance that you plan to use for a new typical or custom installation does not contain databases named AOM2 or DPM. CA Virtual Assurance creates these databases during installation.
2. Verify SQL Server Client requirements

   Verify that the SQL Server Client is installed on the local CA Virtual Assurance manager system. CA Virtual Assurance manager requires the SQL Server Client to connect to a local or remote SQL Server. The CA Virtual Assurance manager installation program uses the available system PATH entries to access the SQL Server Client programs.

More Information

Install and Configure SQL Server Express