11.0

On this page, specify the following:

a) Type of database server: Oracle or MS SQL

Note: If you plan to use an Oracle database server, you must configure it before creating a

database (see Oracle database settings).

b) Name of new database (if MS SQL Server is selected). Note the limitations imposed by MS SQL on

database names (see http://msdn.microsoft.com/en-us/library/ms175874.aspx).

c) A user with DBA permissions on SQL or Oracle server.

Note: If MS SQL Server is installed on a different computer than the Application Server,

then Database Server Authentication must be used to connect to the database server.

Note: If MS SQL Server is used, then we recommend choosing the TCP/IP protocol rather

than Named Pipes to communicate with the database server (the protocol is specified

when you configure MS SQL Server Client, which is installed on the computer hosting the

Application Server).

d) Select the “Use external file storage” option and specify the path to the file storage location. The file

storage location stores the images to be processed and metadata. The speed of communication be-

tween the Application Server and the file storage location greatly affects the performance of the en-

tire system. Therefore, we recommend placing the file storage location in a folder that is local to the

Application Server. To achieve maximum performance, we recommend placing the file storage loca-

tion on the same physical drive as the IIS temporary folders. The drive itself must be a high-

performance drive. You can also use a high-performance external device to store data (for more de-

tails, see Recommendations for setting up ABBYY FlexiCapture).

Note: If no file storage location is used, all project files are stored in a database. For small

amounts of processing, the two solutions are equivalent in terms of performance and secu-

rity. Storing project files in a database makes backing up and restoring data easier, but for

large amounts of processing, it increases the size of the database, which may decrease the

system’s performance. Therefore, storing project files in a database is recommended only

for demonstration projects.

Note: A file storage folder must be excluded from the scope of anti-virus software and the

Windows indexing service that enables fast searching.

e) Use the Test Connection button to check the entered values. If the test is successful, click OK.

To create a database, follow these steps:

1) If Database Server Authentication is used, the database is created on behalf of the user ac-

count specified on the Service -> Application Server page of the Administration and Monitor-

ing Console. If Windows authentication is used, the database is created on behalf of the user

account under which the browser with the Service -> Application Server page is started.

To create a database in MS SQL, the user must have the following permissions: