Skip to main content
Version: Axidian Privilege 2.10

Databases

To store data, Axidian Privilege uses the following databases:

  • Core — Axidian Privilege Core component database is used to store Axidian Privilege privileged accounts, resources, permissions, and other service data.
  • CoreJobs — Axidian Privilege Core component database is used to store scheduled jobs.
  • Idp — IdP component database is used to store authenticators of Axidian Privilege users and administrators.
  • IdpJobs — IdP component database is used to store scheduled jobs.
  • LS — Log Server component database is used to store the Axidian Privilege events.

Database Creation​

  1. Launch Microsoft SQL Management Studio (SSMS) and connect to Microsoft SQL Server instance.
  2. Open the context menu of Databases item.
  3. Select the New Database item.
  4. Specify a database name, for example Core, CoreJobs, Idp, IdpJobs, LS.
  5. Click ОK.

Creating a Service Account to Work with Data Storage​

  1. Start Microsoft SQL Management Studio (SSMS) and connect to the Microsoft SQL Server instance.
  2. Expand the Security item.
  3. Open the context menu of Logins item.
  4. Select the Create login item.
  5. Enter the name, for example IPAMSQLServiceOps.
  6. Select SQL Server authentication item and fill in the required fields.
  7. Switch to User Mapping item.
  8. Check Core, CoreJobs, Idp, IdpJobs and LS databases.
  9. Check database roles db_owner, db_datareader and db_datawriter.
  10. Click ОK.
note

The grants db_owner for Microsoft SQL Server is required only for the first access to the database.

note

A certificate for the MSSQL instance is required for Axidian Privilege.