System Requirements › Manager Requirements › Database Requirements
Database Requirements
CA Server Automation uses Microsoft SQL Server as its database. Because CA Server Automation integrates with other CA products, review the database requirements for integration products.
This release supports the following versions:
- 2005 SP3 or greater (32 bit, 64 bit), Standard and Enterprise Editions
- 2008 SP2 (32 bit, 64 bit), Standard and Enterprise Editions
- 2008 R2 (32 bit, 64 bit), Standard, and Enterprise Editions
- 2008 R2 Express (32 bit, 64 bit), Database with Management Tools, and Database with Advanced Services Editions
Note: SQL Server Tools (OSQL.EXE) are required.
Note the following:
- For your convenience, SQL Server 2008 R2 Express Edition (32 bit) is available on the CA Server Automation installation media at the following location: DVD1\Installers\Windows\External\MSSQLExpress\setup.exe.
- Named instances and SQL Server clusters are supported. TCP/IP must be enabled, and static port assignments must be used for each instance. Dynamic ports are not supported.
- The system installed with the manager components must also have the SQL client installed.
- After installing SQL Server Tools, check to see that OSQ.EXE is properly installed to this location (if using the default install path):
- MS SQL 2005: C:\Program Files\Microsoft SQL Server\90\Tools\Binn
- MS SQL 2008: C:\Program Files\Microsoft SQL Server\100\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 SP2, R2, or R2 Express database requires either a local 2008 SP2, R2, or R2 Express Native Client.
- A remote 2005 SP3 database requires a local 2005 SP3 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 (2005 SP3+ or 2008 SP2+).
- Download and install the appropriate module for your operating environment on your local system.
Example: ENU\<x86 or x64>\sqlncli.msi
