De-integrating AD/LDAP from Java and Unified Management Console

Products

• Data Center Security Server Advanced

Issue/Introduction

How to de-integrate AD/LDAP from Java and Unified Management Console (UMC) Web Portal

Environment

Release :DCS 6.8MP2, 6.9.0

Component : Java Console and UMC Web Portal

 

 

Cause

Currently UMC Webportal Graphical User Interface(GUI) does not provide any method or way to de-integrate existing Active Directory\LDAP Connection.

Resolution

To remove AD integrated with UMC console.

• Remove the entry of directory server from "dcsc_umc" Database
  Note : Before making any changes in DB, make sure you have backup copy of the DB available for restoration.
• Also note that on de-integrating AD from UMC console, the only user which can be used for login is dcsadmin. Or, there should be another DC integrated with UMC that one can continue to use.
• Make sure that another DC integrated with UMC and user from that AD can login successfully as an UMC administrator
• Now use SQL Server Management studio to run the following queries on dcsc_umc Database:
  use dcsc_umc
  select * from security.domains
• Note down the "domainid" of the domain which is to be de-integrated.
• Run following query to remove the AD:
  use dcsc_umc
• SQL Query: delete from security.domains where domainid = <domainid of domain to be removed>
  The domain will be de-integrated now.