Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Headers capitalization.

Databases in Use

Axidian Privilege uses Microsoft SQL Server or PostgreSQL Pro to store data. The following components require databases:

  • IPAMCore Axidian Privilege Core component database is used to store Axidian Privilege privileged accounts, resources, permissions, and other service data
  • IPAMCoreJobs Axidian Privilege Core component database is used to store scheduled jobs
  • IPAMIdp — IdP component database is used to store authenticators of Axidian Privilege users and administrators
  • IPAMIdpJobs — IdP component database is used to store scheduled jobs
  • ILS Log Server component database is used to store the Axidian Privilege events

Database

creation

Creation

Divbox
stylebackground:#FAFAFA


Expand
titleMicrosoft SQL Server
  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 IPAMCoreIPAMCoreJobsIPAMIdP, IPAMIdpJobs, ILS
  5. Click ОK


Creating a

service account

Service Account to

work

Work with

data storage

Data Storage

Divbox
stylebackground:#FAFAFA


Expand
titleMicrosoft SQL Server
  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 IPAMCoreIPAMCoreJobsIPAMIdP, IPAMIdPJobs and ILS databases
  9. Check database roles db_ownerdb_datareader and db_datawriter
  10. Click ОK



Note
iconfalse

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


Note
iconfalse

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



Divbox
classrightFloat

Table of Contents
printablefalse