11.0

Database server

SQL

• For the Application Server to work, MS SQL Server is required (for the supported versions, see System Require-

ments). On the server, the "Mixed Mode" ("SQL server and Windows authentication") must be enabled for authentica-

tion. The installation CD contains MS SQL Server 2005 Express. It can be used for demonstration purposes and small

projects. This version limits the database size to 4 GB. If another edition or a newer version of MS SQL Server is in-

stalled on your computer, you can use that edition or version.

Required SQL Server Collation: SQL_Latin1_General_CP1_CI_AS.

Note: Microsoft Azure SQL is not supported.

Oracle

• Instead of SQL Server, the Oracle Server can be used as a database server (for the supported versions, see System

Requirements). For this, a 32-bit client for the Oracle database must be installed.

Important! By default, an Oracle database allows a maximum of 40 processes and 49 sessions. When these limits

are reached, the following error message occurs: “ORA-12516: TNS:listener could not find available handler with

matching protocol stack.”

If required, increase the default values by using a script similar to the following:

connect sys/<Login> as sysdba;

alter system set sessions=<SessionCount> scope=spfile;

alter system set processes=<ProcessCount> scope=spfile;

shutdown immediate;

startup;