Administration Guide > Installation > New Installation > MS SQL Server

MS SQL Server

This guide includes the individual steps for setting up an MS SQL databaseA database is an organized collection of data including relevant data structures. for AE usage.

Refer to the reference section of the AE database in order to optimize performance. See:Configuration & Performance of the Database 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 Engine 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 ILMStands for Information Lifecycle Management, which refers to a wide-ranging set of strategies for administering storage systems on computing devices. (Information Lifecycle Management). Automic recommends reading the document about"Maintaining the data records"before you set up the database.

Disk Space Required

Size required for the initial installation of an AE database
Test systems:	1 GB
Production systems:
Small systems	5 - 20 GB
Medium systems	20 - 50 GB
Large system	more than 50 GB

Procedure

	1.	Requirements

DB computer
MS SQL Server must be correctly installed and ready to run
Installation settings:

Use standard code page "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.

	2.	Setting up the database

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 passwordA secret combination of characters for a Automation Engine user. 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)