Creating a database manually

To create a database manually:

  1. Create a blank database.
  2. For an SQL database, run the Description.sql script.
    For an Oracle database, run the Description_Oracle.sql script.
    Note: By default, the scripts are placed into the C:\inetpub\wwwroot\FlexiCapture12\Server folder on the computer where the Application Server is installed.
  3. For an SQL database, run the DBInitFill.sql script.
    For an Oracle database, run the DBInitFill_Oracle.sql script,
    Note: By default, the scripts are placed into the C:\inetpub\wwwroot\FlexiCapture12\Server folder on the computer where the Application Server is installed.
  4. 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 )

  1. 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.
  1. Specify the system administrator roles for the newly created user:

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

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

SQL database users

For details about user permissions, see Permissions required for creating and configuring a Microsoft SQL database.

01.12.2020 7:03:59


Please leave your feedback about this article