Install the Domain Orchestrator › Prerequisites to Installing the Domain Orchestrator › Database Prerequisites › Prepare a Microsoft SQL Server Database for CA Process Automation › Verify that the SQL Server Database Meets CA Process Automation Requirements

Verify that the SQL Server Database Meets CA Process Automation Requirements

The SQL Server that you prepare for CA Process Automation data stores must meet the following requirements:

• SQL Server must be installed or configured with mixed mode authentication. You specify an account with SQL Server authentication during the Orchestrator installation.
• The Orchestrator installer requires user credentials with Administrator privileges to create the databases for the CA Process Automation data stores.
• SQL Server collation must be SQL_Latin1_General_CP1_CI_AS for databases that hold the CA Process Automation data stores. By default, the CA Process Automation installer creates databases with this collation.

Examine the configuration file for your SQL Server to verify that your SQL Server meets CA Process Automation requirements.

Follow these steps:

1. Navigate to the ConfigurationFile.ini file, which is created in a path similar to the following:

   C:\ Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ yyyymmdd_hhmmss
   

2. Verify that the security mode setting resembles the following:

   ; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication. 
   

   SECURITYMODE="SQL"
   

3. Verify that the setting for the SQL system administrator account credentials resembles the following:

   ; Windows account(s) to provision as SQL Server system administrators. 
   SQLSYSADMINACCOUNTS=".\Administrator"
   

4. Verify that the setting for collation resembles the following:

   ; Specifies a Windows collation or an SQL collation to use for the Database Engine. 
   SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"