While removing the credential from credential manager, it fails to remove the credential.
Error: Credentials cannot be deleted if there are in use.
Make sure those credentials are not in use with any discoveries, and none of the discovery nodes are using the account or with ER service account.
Login to SQL server using the service account and then try to access the Enterprise Reporter database (dbReporter by default).
Before doing any steps, take a full backup of the database and follow below steps.
Check under the Tables | go to dbo.tblCredentials | right click on it and Edit Top 200 Rows
You will see all the credentials and look for the account you want to remove and delete the entire row.
Then restart the Enterprise Reporter services and the user will be removed.
