11.0

© 2014 ABBYY Production LLC. All rights reserved.
55
- 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 run-
ning.
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 located on the computer where the Application Server is installed at <IIS Root
Directory (by default “C:\inetpub\wwwroot”)>\FlexiCapture11\Server. The first file is responsible
for creating a database, while the second one is responsible for its contents. Files Upgrade*.sql
located in the same folder are not used when creating a new database.
2) In the case of MS SQL, a new user account, under which the FlexiCapture 11 Web Services
pool of the Application Server Web service is running, is added to the database server (by de-
fault, the pool of the Application Server is started under the user account Network Service).
3) db_owner rights to the FlexiCapture database created in step 1 are assigned to the new user
account created in step 2 (if MS SQL is used). All further operations concerning server interac-
tion with the database are performed on behalf of the user created in step 2. The account used
for creating a database in step 1 can be deleted from the database server if necessary.
In the case of Oracle, all further work with the database during the operation of ABBYY
FlexiCapture is performed under the account used for creating the database in step 1; no addi-
tional accounts are created (in contrast to MS SQL).
4. If you are using FlexiCapture authentication (for this, the Authentication Module must be installed), then, after
creating a database, you will receive a message saying that a temporary password password has been
created for your account.
To continue working with the system, it is necessary to change the password. For this, go to the login page
(http://<server name>/FlexiCapture11/Login).
When trying to open any page of the Administration and Monitoring Console after creating a database, the
user will be automatically redirected to the login page to change the password. Once the password is
changed, the user will be returned to the page of the Administration and Monitoring Console.
5. The user who created the FlexiCapture database automatically gets administrative privileges for the system.
The administrator also has the right to change the settings of the Application Server, upload projects to the
Application Server, grant access rights for projects, create new users, and manage their roles and access
rights.
The administrator of the system can grant the administrator role to another user and delegate further configu-
ration of the system to that user. The user who created the database cannot be deprived of the administrator
role, neither can that user’s account be deleted from the system.
Connecting to an existing database
Instead of creating a new database, you may need to connect to an existing database created in one of the previous
releases of ABBYY FlexiCapture (see Upgrading from ABBYY FlexiCapture 9.0 and 10).
Important! Under Windows Vista, Windows 2008 or later versions of the Windows operating system, UAC must be
disabled on the computer where the Application Server is installed before connecting to the database.
To connect to an existing database, do the following:
1. On the computer where the Application Server is installed, run the Administration and Monitoring Console
under a user account with Windows administrator privileges and go the page Service -> Application Server
(http://<server name>/FlexiCapture11/Monitoring/DBConnection.aspx).
If the Application Server is already connected to a database, go to step 4.
2. Click Connect to Existing Database.
3. In the form that opens, fill in the following fields: type of database server, name of the existing database (if
MS SQL Server is used), the user who is the administrator of the database server, path to the file storage lo-
cation (if a file storage location is used). Click OK.
4. Now your server is connected to the database. If the Upgrade link is displayed on the Service -> Applica-
tion Server page (http://<server name>/FlexiCapture11/Monitoring/DBConnection.aspx), next to the data-
base version, then you should upgrade the database before you proceed.