Setting Up the AE Database

The following steps will help you set up the Automation Engine database.

Click the image to expand it.

To Set Up the AE Database

1. Database rights for the Automation Engine

   No further steps are required at this point (provided you have followed the preparation steps).

   The database user requires the "db_owner" role. To add it, use the following SQL query:

   sp_addrolemember 'db_owner','uc4'

    

2. Create an ODBC Data Source

   Note that it is important to set the SQL cursor (1st digit=S) or to activate MarsConnection in the INI-file parameter for the ODBC access (SQLDRIVERCONNECT= ) in the particular component (Automation Engine, utility). Otherwise, the SQL Server database can only process one command at at time, which results in the following error:
   U0003590 DB error: 'SQLExecDirect', 'ERROR ', 'HY000', 'Connection is busy with results for another command'

   1. Decide whether you want to create the data source as a User DSN (user specific) or as a System DSN (once for all users of this computer).

      Automic recommends using the System DSN.

      A System DSN must be set up if the Automation Engine should be run as a service on this computer.

   2. Click the System DSN tab.

      

   3. Click Add... to add a new data source.
   4. Select SQL Server.

       Note that the SQL native client is required in order to use the AE database with MARS. You can download it from the Microsoft homepage, if it is not yet installed on your computer.

   5. Some basic settings are required in the following dialog box:

      

      1. Enter the name and description of the data source.
      2. Select local if the SQL Server is on the same computer, otherwise enter the name of the DB  computer.
      3. Click Next >.

   6. Select "SQL Server authentication" and enter the login ID and password in the following dialog box.

      Automic recommends creating a separate database user for AE.

      Do not use the user "sa" (system administrator).

      

   7. Click Next >.
   8. Now select the database.

      

   9. Select the required options in the last dialog box.

      Note that the third check box "Perform translation for character data" must not be selected.

      

   10. Click Finish.
   11. Click TestData Source to check the configuration,
   12. Click OK.

   Potential Problems

   • 32-Bit ODBC is used instead of 64-Bit ODBC.
   • The check box "Use ANSI nulls, paddings and warnings" is not activated.

Preparation Steps Progress

Next steps:

• Installing the Utilities
• Loading the AE Database
• Install the AE
• Install the Online Documentation
• Installing the Agents
• Installing the Additional Components

Previous Steps:

• Security Setup for Super Users