Relying Party: SQL Database

IDMS can relay certificate and device information to a database to centrally store the credentialing information for all users with devices.

Prerequisite:

SystemManager account permission

The SQL table called CertificateTracker. The SQL Creation script is located in the following IDMS installation folder: IDMS Client\CMS Notification. The SQL script name is createRelyingPartyTable.sql. This script will create the required table.

Creating the Connection

After the table has been created, the procedures below will connect the IDMS to the respective table.

	Procedure	Example
1	Go to Administration, System Connections
2	Click, + System Connection, Select Relying Party
3	In the Directory Type Dropdown, select SQL Database
4	Enter the DNS Name, port, Authentication Type, Database Name, and Table Prefix. Table Prefix: use DBO
5	Once complete, press the check button to verify the CMS connection is successful.