Versions Compared

Old Version 2

changes.mady.by.user Mikhail Yakovlev

Saved on

compared with

New Version Current

changes.mady.by.user Daliya Agletdinova

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Indeed Certificate Manager system database used as data storage is a database. The database is created manually and is populated using created manually. To populate the database, use the Storage.sql script from the Indeed CM included in the Axidian CertiFlow installation package (.. \IndeedCMCertiFlow.Server\Misc).change

Database creation

Creating a database

1. Create a database in SQL Management

Studio environment

Studio environment with an arbitrary name

(say, IndeedCM):

:

  • In Object Explorer, right-click on Databases tab.
  • Select New Database.
    • Define the login name
  • Specify the Database Name
  • (e.g.
    • , IndeedCMSQL
  • CertiFlowDB) andclick OK.
info

Image Added

2. Use a local SQL account (for example, cfServiceSQL) or Windows domain account and define permissions for your database. This account

shall

will be used to perform

reading data from

read and write operations to the database

and writing data to it. Connection of the

. You can connect this account to the database

is carried out with Indeed CM

in Axidian CertiFlow Setup Wizard.

  • Define
    • the permissions
  • Logins for the created database
    • for the said login name as follows
  • (e.g. cfServiceSQL).
  • Click Security→Logins, select an account from the list.
  • Go to User Mapping tab.
  • Grant permissions for the selected login to work with the database, specify permissions: db_owner
    • , public (Figure 7):

Image Removed

Figure 7 – Microsoft SQL: permissions for working with database.

  • and public.
  • Click OK.

Image Added

3. Select

2. Open

the created database in

SQL Management Studio environment

Object Explorer and execute the Storage.sql script:

    Select
  • Choose File
    • – menu
  • →Open
    • – File. . .
  • →File (or Ctrl+O), specify the path to Storage.sql file (located in ..\
    • IndeedCM
  • CertiFlow.Server\Misc
    • \ folder of Indeed CM installation package
  • change directory) and click Open.
    • .

3. Click Execute and refresh the contents in Object Explorer after script execution is complete.
Expected result is that IndeedCM database contains the following tables in the Tables section:

  • dbo.Cards
  • dbo.CardTypes
  • dbo.Licenses
  • dbo.Policies
  • dbo.Users
    • Before executing the script, uncomment: --USE [<database name>] --GO and specify the name of the database for which the script is applied (CertiFlowDB): --USE [CertiFlowDB] --GO. Or select the required database in the drop-down menu.
    • Click Execute. 

    Image Added

    etc.