check database

The EDCMonitor checks the Recognition database; if the CustomerName/CustomerID exists.

• If yes, the entry will be set to ACTIVE or stays active
• If the customer hasn’t been found, the entry will be set to INACTIVE

SELECT DISTINCT [CustomerIdentifier] FROM [Mandator] WHERE NOT CustomerIdentifier IS NULL AND [Active] = 1

Check Mandator (customer name)

If the activation always gets reset to INACTIVE, check the following:

CustomerID/CustomerName must be the same.

SpiderDataCollector.cfg

SpiderDataReceiverRegister.csv - customer name must be the same as it gets registered by the SpiderDataCollector
--> This activation status can’t be set manually. It will be reset by the EDCMonitor

 *see also https://community.flexera.com/s/Spider-Knowledge-Base/A-new-Spider-Datacollector-Server-does-not-connect-to-the-Spider/ta-p/224860

Check if the Mandator exists in Spider and has the same name as in the SpiderDataCollector.cfg (Menu > System > Mandators).

Check EDC Monitor log

If this still fails, check the EDCMonitor SmartInspect log 

If there’s a connection issue to the DB, check the connection string in EDCMonitor.exe.config.

Make sure that Username and Password are correct

Further, check the SQL server logs for more information about the connection issue. Event viewer might not show the full reason due to security restrictions.

Sync user after a database has been restored

If you have restored a database, you might need to sync the SQL user. The DB might show the correct username, but this might not be the same because of the user SID. Therefore, you need to update the user “spider” with “spider” as follows:

use Recognition
go
EXEC sp_change_users_login 'Update_One', 'spider', 'spider'
go

Sync user after a database has been restored

If you have restored a database, you might need to sync the SQL user. The DB might show the correct username, but this might not be the same because of the user SID. Therefore, you need to update the user “spider” with “spider” as follows:

ALTER USER spider WITH LOGIN=spider