System Center Operations Manager can’t monitor SQL Server Analytics Platform System appliance

Applies to: SQL Server 2012 Parallel Data WarehouseSQL Server 2008 R2 Parallel Data Warehouse

Symptoms


Consider the following scenario:

  • You installed the Microsoft System Center Operations Manager Management Packs.
  • You add a SQL Server Analytics Platform System (APS) appliance by running new-apsappliance.ps1.
  • You set up the Watcher and Monitoring accounts.

In this scenario, the appliance isn't monitored, and you experience one of the following issues:

  • Issue A: The appliance isn't discovered and isn't visible in Operations Manager.
  • Issue B: The appliance is listed in Operations Manager but is in the NOT MONITORED state.

Cause


This issue is caused by an error that occurs during discovery. To see the error information, check the Operations Manager event log on the watcher node. The following error scenarios can occur.

Scenario A

  • Errors for the APS watcher account, such as an incorrect password

Scenario B

  • Error logged in the event log:

    Note This is an ambiguous error. APS no longer requires a DSN. The appliance information is added and used in the registry.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Resolution


To fix this issue, follow these steps as appropriate for the error scenario.

For Scenario A

  1. Correct the password in Operations Manager.

For Scenario B

  1. Verify that the appliance is added to the registry of the watcher node.

    Note The IP that's specified must be for the APS Control Node IP. It should be located under the following registry subkey:

     
    HKLM\SOFTWARE\Microsoft\Analytics Platform System\Management Pack\Appliances
  2. Verify that SQL Server Native Client is installed.