MS SQL Server

This guide includes the individual steps for setting up an MS SQL database for AE usage.

Refer to the reference section of the AE database in order to optimize performance. See: MS SQL Server and the list of supported database versions.

Do not limit resource consumption. Aborting transactions due to limitations specified in the database can impede processing in the AE system. Additionally, inconsistent database contents can result, which can cause subsequent errors or endless loops.

Note that modifying database contents results in an inconsistent database.

Do no activate the option "autoshrink" in the database. This can occasionally cause a Automation EngineCe composant commande un système Automation Engine. Il se compose de plusieurs processus serveur. standstill.

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 the time which results in the following errort:
U0003590 DB error: 'SQLExecDirect', 'ERROR ', 'HY000', 'Connection is busy with results for another command'

You can maintain the AE database by using partitioning with ILMSignifie Information Lifecycle Management (gestion du cycle de vie des informations), et se réfère à un large ensemble de stratégies permettant d'administrer les systèmes de stockage de calculateurs. (Information Lifecycle Management). Automic recommends reading the document about"Maintaining the data records"before you set up the database.

Disk Space Required

Procedure

	1.	Requirements

• DB computer
• MS SQL Server must be correctly installed and ready to run
• Installation settings:
• Use either code page:
  • "Latin1_General_CI_AS"
  • "SQL_Latin1_General_CP1_CI_AS" (CP 1252)
• Use standard Sorting.
• Terms are case-insensitive (alphabetical order, regardless of case).
• 64-bit clientEnvironnement indépendant pour la création et l'exécution d'objets dans un système AE. Le nom d'un client est un nombre de quatre chiffres à saisir lors de la connexion d'un utilisateur au système AE. Les utilisateurs et leurs droits y sont aussi définis.Egalement un type d'objet distinct dans l'Automation Engine. must be installed.

• DB computer
• Start SQL Server if it has not already been started (ServiceManagerProduit(s) : AE, RA_JMS. Le ServiceManager permet de démarrer ou d'arrêter des composants, tels que des processus d'Automation Engine ou des agents, depuis un point central.).
• Start the SQL Server Database Management program.
• Create a new database for example with the name "AE." The size of the transaction log should be about 25% of the data-file size (for test systems with truncate log).

	3.	Creating a database user

• DB computer
• Create a new user called "AE" in the SQL Server Enterprise Manager (in the "Security" folder).
• Select the authentication in the General tab and enter a keyword of your choice. The standard database is the AE Database.
  Automic recommends using SQL Server Authentication.
  Ensure that the database password does not include the special characters [ ] { } ( ) , ; ? * = ! @ \. Otherwise, the components cannot access the database.
• Highlight the AE database in the Database access tab and select public, db_owner, db_ddladmin, "db_backupoperator, db_datareader and db_datawriter in the database roles.
• The Database user must also have permissions to execute Stored Procedures whose names start with "UC_".

	4.	Setting up the Data Source

• Admin computer
• Set data source AE for ODBC access (64 bit ODBC)