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:

  1. Install FlexiCapture Application Server.
  2. Open the Application Server IIS folder: C:\inetpub\wwwroot\FlexiCapture12\Server
  3. Find there .sql script files.
  4. Create a blank database.
  5. Run the Description.sql script via Microsoft SQL Server Management Studio for a newly created blank DB.
  6. Run the DBInitFill.sql script. It populates the database with data.
  7. 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 )
  8. Add the first user:
    INSERT INTO principal (Name, FullName, EMail, PasswordHash, PasswordReset) values (N'Login', N'FullName', N'email', '', 0)


    • 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.
  9. Specify the system administrator roles for the newly created user:
    INSERT INTO principalpermission (PrincipalId, RoleType, IsAllowed) values (1, 10, 1).
  10.  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:

Was this article helpful?

2 out of 2 found this helpful

Have more questions? Submit a request



  • Avatar

    K. Aravind

    Thank you so much, this was so helpful for me.

  • Avatar


    Just a note for step 9. You may want to remove the "." from the end of the sql statement.


Please sign in to leave a comment.