Hi,
Running scom 2019 UR1 and SCSM 1019.
Running SCSM MP 10.21.1124.0.
DW management server and SM management servers are discovered.
Management groups and workflows and databases are not discovered.
On the proxy i see there errors.
The process started at 12:16:38 PM failed to create System.Discovery.Data. Errors found in output:
C:\Program Files\Microsoft Monitoring Agent\Agent\Health Service State\Monitoring Host Temporary Files 25\3553\Dw2012DatabaseDiscovery.VBS(61, 1) Microsoft VBScript runtime error: Subscript out of range
Command executed: "C:\Windows\system32\cscript.exe" /nologo "Dw2012DatabaseDiscovery.VBS" {F632AEBF-D0AA-8E9E-C1C8-3D8002C2212B} {449F1626-11BE-DD7D-2FC4-0838A7261A0B} dwserver.blabla.bla
Working Directory: C:\Program Files\Microsoft Monitoring Agent\Agent\Health Service State\Monitoring Host Temporary Files 25\3553\
One or more workflows were affected by this.
Workflow name: Microsoft.SystemCenter.ServiceManager.Dw2012Database.Discovery
Instance name: dwserver.blabla.bla
Instance ID: {449F1626-11BE-DD7D-2FC4-0838A7261A0B}
Management group: SCOM
OleDb Module encountered a failure 0x80004005 during execution and will post it as output data item. Unspecified error
: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Workflow name: Microsoft.SystemCenter.ServiceManager.WWFWorkflows.Monitor
Instance name: smserver.blabla.bla
Instance ID: {CFF3FECA-5C75-7A9C-69DA-DD7D725A7BF1}
Management group: SCOM
OleDb Module encountered a failure 0x80040154 during execution and will post it as output data item. Class not registered
: Class not registered
Workflow name: Microsoft.SystemCenter.ServiceManager.WWF.Monitoring.RuleRunning
Instance name: hob-mg-0090.NUCLEUS.ATOM.ADS
Instance ID: {CFF3FECA-5C75-7A9C-69DA-DD7D725A7BF1}
Management group: SCOM
According to the guide this could be a permission issue, but when i run a wireshark on the proxy, i can clearly see communication to the sql and reponses to the query's send.
Anyone who can point me in the direction to solve this issue?