EM 12c: MSSQL Discovery in Enterprise Manager 12c Cloud Control Fails With Failed To Connect, Connection Reset, when "Force Encryption" is enabled.
(Doc ID 1963044.1)
Last updated on JANUARY 03, 2017
Applies to:Enterprise Manager for Miscellaneous Plug-ins - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
When trying to discover the MSSQL target in Enterprise manager (EM) 12c Cloud Control, the test connection fails with:
, _Wbem_Remote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [iscluster] (iscluster), _MSSQL_Instance_TestMetric_DynamicProperty;Failed to connect,
, _OS_Type_TargetHost_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), MSSQL_NumClusterNodes;Failed to connect,
The Microsoft SQL Server instance has "Force Encryption" set to yes for connectivity protocols
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