If you are experiencing data consistency issues (non-clustered environment) or two servers that are functioning like they are the cluster coordinator, you might have issues with Configuration Storage (ConfigStore) settings.
Query the ConfigStore database to diagnose server connection issues. Using a SQL client against the ConfigStore database (non-OBD databases only), view the CFG_CLIENT_DATA table which contains information about client connections and details.
The connection information in the CFG_CLIENT_DATA table can help to:
In a Non-Clustered Environment: Verify that there isn’t more than one server using the ConfigStore.
If you find more than one server connecting to the ConfigStore database, reconfigure your servers so that only one connects to each ConfigStore.
Clustered Environment: Verify that all servers are connecting the same ConfigStore.
In a clustered environment, all servers must point to the same ConfigStore database. If you find a clustered server not connecting to the correct ConfigStore, change the Configuration Storage settings using the server’s Configuration Manager.
For information about configuring Configuration Storage, see Configuring the Database for Configuration Storage
in the Operations Center Server Configuration Guide.