My Oracle Support Banner

EM13c: Discovering Microsoft SQL Server 2022 Fails Due To Missing MSVCP100.dll (Doc ID 2980346.1)

Last updated on NOVEMBER 17, 2023

Applies to:

Enterprise Manager for Miscellaneous Plug-ins - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Enterprise Manager (OEM) Microsoft SQL Server discovery fails.

Test Connection failed: [_OS_Type_Agent_DynamicProperty;Command exited abnormally without any output, _WinAuthDLLToLoadDynamicProp;

DB Credentials are found missing. DB Credentials are required for SQL based connections

, MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _Wbem_Remote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _MSSQL_Instance_TestMetric_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _MSSQL_Existence_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), _MSSQL_Existence_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), _MSSQL_Existence_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), _OS_Type_TargetHost_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile)]

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.