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).
Database creation
1. Create a database in SQL Management Studio environment with an arbitrary name (say, IndeedCM):
- Define the login name (e.g., IndeedCMSQL).
Use a local SQL account or Windows domain account. 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 permissions for the database for the said login name as follows: db_owner, public (Figure 7):
Figure 7 – 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.
Expected result is that IndeedCM database contains the following tables in the Tables section:
- dbo.Cards
- dbo.CardTypes
- dbo.Licenses
- dbo.Policies
- dbo.Users
- etc.