Unable to configure agent manager connection

  • 7017731
  • 15-Jun-2016
  • 15-Jun-2016

Environment

NetIQ Sentinel 7.4x Sentinel Server

Situation

When trying to configure\synchronize a new Sentinel server with a Sentinel agent manager database that was previously associated with another Sentinel system the following error is occurring. 

Error Message: “Test Connection successful, but the database is currently associated with another Sentinel System.”






Resolution

 1. Open  SQL Server Management Studio and connect to the SQL server where the AgentManager database resides. 
 2. Clear the old Sentinel server entries by running the following queries.

use agentmanager update Configuration set DataValue='' where DataName='SentinelServerId'
use agentmanager update Configuration set DataValue='' where DataName='SentinelServer'

Note: The entries right after DataValue= are 2 single quotes, NOT a double quote.
Note: This will set the Datavalue to blank which manually disassociates the old Sentinel server. 

3. Go to the new Sentinel Server webui\collection\agent manager\
4. Configure the agent manager connection.
5. test and save.

Cause

Whenever a Sentinel agent manager database has been previously associated/synchronized with a different Sentinel server, it must be dis-associated before a new Sentinel server can be synchronized.  Sometimes for different reasons the previous association is not released so you are not allowed to complete the new configuration.