Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Databases names are fixed due to names on the Configuration Files Setup page.

Databases in Use

Indeed Identity PAM uses Microsoft SQL Server or PostgreSQL Pro to store data. The following components require databases:

  • IPAMCoreCore Indeed Identity PAM Core component database is used to store Indeed Identity PAM privileged accounts, resources, permissions, and other service data
  • IPAMCoreJobsCoreJobs Indeed Identity PAM Core component database is used to store scheduled jobs
  • IPAMIdp Idp — IdP component database is used to store authenticators of Indeed Identity PAM users and administrators
  • IPAMIdpJobs IdpJobs — IdP component database is used to store scheduled jobs
  • ILS Log Server component database is used to store the Indeed Identity PAM events

Database 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 IPAMCoreCore,  IPAMCoreJobs CoreJobs,  IPAMIdPIdP, IPAMIdpJobs IdpJobs, ILS
  5. Click ОK


Creating a Service Account to Work with 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 IPAMCoreCore,  IPAMCoreJobs CoreJobs,  IPAMIdP IdP, IPAMIdPJobs IdPJobs 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 Indeed Identity PAM.



Divbox
classrightFloat

Table of Contents
printablefalse