Previous Topic: Host Machine RequirementsNext Topic: Pre-deployment Tasks


Database Requirements

CA DataMinder FastStart uses a Microsoft SQL Server database. CA DataMinder servers need sufficient memory and processing power to run your chosen database. See your database documentation for details.

Supported Database

Note: SQL Server is supported on Windows servers only.

Server Authentication Mode

Configure the CMS to use the correct authentication method, otherwise it will be unable to connect to the SQL Server database.

In SQL Server Enterprise Manager, edit the Security properties of the target CMS server so it uses SQL Server and Windows Authentication Mode (formerly known as ‘mixed mode’).

Network Configuration

Verify that CA DataMinder can connect to SQL Server over a network:

SQL Server Browser Service

Verify this service has started. By default, this service is off.

TCP/IP

Enable the TCP/IP protocol. By default, this protocol is disabled.

Static IP Ports

The CMS connects to the DBMS using static ports. If your database host server uses dynamic ports, reconfigure the SQL Server instance hosting the CA DataMinder database to use static ports. This is particularly important if your CMS uses SQL Server 2005 Express.

Full details are in the Database Guide. In particular, see the ‘SQL Server Guidelines’ chapter.