Install the Components › Install CA Process Automation › Prepare Microsoft SQL Server

Prepare Microsoft SQL Server

The Microsoft SQL Server must fulfill the prerequisites for installing CA Process Automation.

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

Follow these steps:

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

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

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

   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 text:

   ; Windows account(s) to provision as SQL Server system administrators.

   SQLSYSADMINACCOUNTS="hostname\Administrator"

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

   ; Specifies a Windows collation or an SQL collation to use for the Database Engine.

   SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"