Cannot delete node because the computer is no longer available or online (4220464)

When trying to remove a node but the computer the node was installed on is no longer available. The node removal fails and the node is still shown in the Configuration Manager.

1. Ensure there are no discoveries running
2. Open SQL Server Management Studio and connect to the SQL server where the Enterprise Reporter database is hosted
3. Expand Databases
4. Backup the ER database
5. Right click the ER database and select New Query
6. Paste the following into the query window:

USE ERDBName

UPDATE [tblDiscoveryNode] SET [Status] = 'FailedToDeploy' WHERE [ComputerName] ='ComputerNameOfNode'

1. Replace ERDBName with the name of your ER databaes and replace ComputerNameOfNode with the name of the computer where the node was installed
2. Click Execute
3. Close the Configuration Manager
4. Restart the Quest Enterprise Reporter Service
5. Once the service has restarted open the Configuration Manager
6. Select Manage Discovery Clusters
7. The node will now show as having a status of "failed to deploy"
8. Right click the node and select Remove Node
9. Click OK to the Remove Discovery Node popup

The following error may be displayed when you try to remove the node:

"At least one of the selected nodes is currently processing tasks. Either allow the tasks to complete or cancel them, and then try again."

If there are no discoveries running, please run the following SQL script against the ER database which will mark all tasks in the database as finished. Once the script has completed, try removing the node again:

update [tblTask] set Status = 'Finished', AssignedNodeID = null, EndDate = StartDate, SeqNo = null where [Status] not like '%%Finished%%' 

update [tblJobRun] set Status = 'Finished', EndDate = StartDate, SeqNo = null where Status not like '%%Finished%%'