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 EngineDiese Komponente steuert ein Automation Engine-System. Besteht aus verschiedenen Serverprozessen. 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 ILMSteht für Information Lifecycle Management, das sich auf eine breite Palette von Strategien zur Verwaltung von Speichersystemen auf Computing-Geräten bezieht. (Information Lifecycle ManagementManagement ist der Funktionsbereich des Service Orchestrator, in dem die Verwaltung von Service Level Agreements (SLAs) durchgeführt wird. In diesem Bereich werden SLA-Definitionen erstellt, bearbeitet und gelöscht. Außerdem dient dieser Bereich auch der Verwaltung Ihrer Geschäftseinheiten.). 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 client must be installed.

• DB computer
• Start SQL Server if it has not already been started (ServiceManager).
• 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)