How to manually create a new MS SQL database in FlexiCapture 12

If for some reason you need to create the FlexiCapture database manually instead of the standard way by using the Administration&Monitoring console, please follow the instruction below:

Install FlexiCapture Application Server.
Open the Application Server IIS folder: C:\inetpub\wwwroot\FlexiCapture12\Server
Find there .sql script files.
Create a blank database.
Run the Description.sql script via Microsoft SQL Server Management Studio for a newly created blank DB.
Run the DBInitFill.sql script. It populates the database with data.

Provide a unique identifier for the database:

INSERT INTO dbo.Settings( Name, Value, ProjectId, BatchTypeId, UserId, Workstation, RoleId, ProcessingStage) VALUES ('DatabaseGUID', NEWID(), NULL, NULL, NULL, NULL, NULL, NULL )

Add the first user:
```
INSERT INTO principal (Name, FullName, EMail, PasswordHash, PasswordReset) values (N'Login', N'FullName', N'email', '', 0)
```
where
- Login is the login that the user will use,
  Important! You must specify the login of the Windows user that will be used to open the Administration and Monitoring Console when connecting to the database.
- FullName is the full name of the user as displayed in their profile, and
- Email is the user’s e-mail address.

Specify the system administrator roles for the newly created user:

INSERT INTO principalpermission (PrincipalId, RoleType, IsAllowed) values (1, 10, 1).

Connect to the newly created database using the Administration and Monitoring Console.

After the database is created and connected to the FlexiCapture Application Server, switch FlexiCapture Application pools back to the Network Service account if such settings are preferred.

After the database is created and user permissions are set up you may connect to it via the Administration&Monitoring console.

Please see ABBYY Online Help for reference:

http://help.abbyy.com/en-us/flexicapture/12/admin_guide/create_database_manually

http://help.abbyy.com/en-us/flexicapture/12/admin_guide/create_database

Roman Podzorov

Was this article helpful?

Comments

K. Aravind

Lachie

Recently viewed