Connector registration issues

Connectors that have lost their registration IDs can be manually retrieved and removed.

Retrieving a connector with a lost registration ID

To retrieve a connector whose registration ID is lost, use the following steps:
  1. Create a text file with the name getConnector.txt in the C:\ directory.
  2. Add the following commands to getConnector.txt:
    use OperationsManager
Select * from Connector
  3. Save the text file.
  4. To retrieve a list of available connectors, run the following command from the command prompt:

    C:\>Sqlcmd -i C:\getConnector.txt

The command output will show a list of all available connectors, with their registration IDs.

Removing a connector with a lost registration ID

Note: You can also remove a connector using the Microsoft SCOM 2016 GUI. Connectors can be removed only when they are not initialized or subscribed to.
To find and remove a connector whose registration ID is lost, use the following steps:
  1. Create a text file with the nameremoveConnector.txt in the C:\ directory.
  2. Add the following commands to removeConnector.txt:
    use OperationsManager
execute [dbo].[p_ConnectorDelete] 'Connector_ID'

    where Connector_ID is the identifier of the connector with the lost registration ID.

    For example: 3C4111C1-E3E5-4415-B3CF-7A61056F5EF2

  3. To remove the connector, run the following command from the command prompt:

    C:\>Sqlcmd -i C:\removeConnector.txt