The Indeed Certificate Manager system data storage is a database. The database is created manually and is populated using Storage.sql script from the Indeed CM installation package (.. \IndeedCM.Server\Misc).
DatabaseData storage creation
1. Create a database in SQL Management Studio environment with an arbitrary name (say, IndeedCM):
To do this, in the Object Explorer, right-click on the Databases tab and select New Database... . Specify the Database Name: for example IndeedCM and click OK (Figure 2).
Figure 2 – Microsoft SQL: permissions for working with database.
2. Use a local SQL account or Windows domain account (for example, servicecm) and define the permissions for the created database. This account shall be used to perform reading data from the database and writing data to it. Connection of the account to the database is carried out with Indeed CM Setup Wizard.
- Define Logins for the created database (for example, servicecm):
Click Security > Logins, select an account from the list. Go to the User Mapping tab and grant permissions to work with the login name (e.g., IndeedCMSQL).
- database for the selected login, specify permissions: db_owner and public and click OK (Figure 3).
Figure 3 – Microsoft SQL: permissions for working with database.
3. Select the created database (IndeedCM) in the Object Explorer and execute the Storage.sql script:
Choose File > Open> File... (or Ctrl+O), specify the path to the Storage.sql file (located in the .. \ IndeedCM.Server \ Misc directory) and click Open.
Before executing the script, uncomment: --USE [<database name>] - GO and specify the name of the database for which the script is applied (IndeedCM): --USE [IndeedCM] - GO. Or select the required database in the drop-down menu (see Figure 4).
Click Execute.
2. Use a local SQL account or Windows domain account (for example, servicecm) and define the permissions for the created database. This account shall be used to perform reading data from the database and writing data to it. Connection of the account to the database is carried out with Indeed CM Setup Wizard.
- Define the login name (e.g., IndeedCMSQL).
- Define the permissions for the database for the said login name as follows: db_owner, public (Figure 2):
Figure 2 – Microsoft SQL: permissions for working with database.
2. Open the created database in SQL Management Studio environment and execute the Storage.sql script:
- Select File – Open – File. . . menu, specify the path to Storage.sql (..\IndeedCM.Server\Misc\ folder of Indeed CM installation package) and click Open..
3. Click Execute and refresh the contents in Object Explorer after script execution is complete.