10.0

© 2011 ABBYY. All rights reserved.
62
Note: If MS SQL server is installed on a different computer than the Application Server, then Da-
taBase Server Authentication must be used to connect to a database server.
Note: If MS SQL Server is used, then for communication with the database server, it is recom-
mended to use TCP/IP protocol instead of Named Pipes (protocol is specified when configuring MS
SQL Server Client which is installed on the computer with the Application Server).
d) Select the option «Use external file storage» and specify the path to the file storage. The file storage stores the
images being processed and metadata. The speed of interaction between the Application Server and the file
storage exerts a strong influence on the performance of the entire system. Therefore, it is recommended to
place the file storage in a folder local to the Application Server. To achieve maximum performance, it is rec-
ommended to place the file storage on the same physical drive as IIS temporary folders. The drive itself must
have high-performance. For data storage it is also possible to use a high-performance external device (for
more details, see Recommendation for setting up FlexiCapture 10).
Note: If
a file storage is not used, all project files are stored in the database. For small amounts of
processing, both solutions are equivalent in terms of performance and security. Storing project files
in database makes backing up and restoring data easier, but for large amounts of processing, it in-
creases the size of the, which may decrease the system performance. Therefore, storing project files
in database is recommended only for demonstration projects.
Note: A file storage folder must be excluded from the scope of anti-virus software and Window in-
dexing service used for quick search.
e) Use the Test Connection button to check the entered values. If the test is successful, click OK.
Creating a database includes the following steps:
1) If Database Server Authentication is used, the database is created on behalf of the user account specified
on the Service -> Application Server page of the Administration and Monitoring Console. If Win-
dows 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:
- CREATE DATABASE, CREATE ANY DATABASE or ALTER ANY DATABASE to
create a database
- ALTER ANY LOGIN to create a new user
- db_accessadmin and db_securityadmin rights to the new database to be able to provide
db_owner rights to the user whose account the Application Server is running.
To create a database in Oracle, the user must have the roles CONNECT and DBA (for more details, see
Oracle database settings
).
On behalf of this user, first the Description.sql (or Description_Oracle.sql if Oracle is used) script and
then the DBInitFill.sql (or DBInitFill_Oracle.sql if Oracle is used) script are executed. The scripts are lo-
cated on the computer where the Application Server is installed at <IIS Root Directory (by default
“C:\inetpub\wwwroot”)>\FlexiCapture10\Server. The first file is responsible for creating a database
while the second one is responsible for its content. Files Upgrade*.sql located in the same folder are not
used when creating a new database.