12c MS SQL Server Plugin 12.1.0.4 connection error: _WinAuthDLLToLoadDynamicProp;Can't resolve a non-optional query descriptor property [url] (url)

(Doc ID 1681633.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

- EM Cloud 12.1.0.3.0

- Upgraded the MS SQL Server plugin from 12.1.0.3.0 to 12.1.0.4.0 

- After the plugin deployment was setup and the sql_auth.dll was copied to the correct directory as per the documentation: http://docs.oracle.com/cd/E24628_01/install.121/e35211.pdf,  the testing of the current SQL Server target still fails with :

_WinAuthDLLToLoadDynamicProp;Can't resolve a non-optional query descriptor property [url] (url)' 'MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [ConnInfo] (url)' '_Wbem_Remote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [jdbcurl] (url)' '_MSSQL_Instance_TestMetric_DynamicProperty;Can't resolve a non-optional query descriptor property [ConnInfo] (url)' '_OS_Type_TargetHost_DynamicProperty;Can't resolve a non-optionalquery descriptor property [STDINWBEM_HOST] (ms_sqlserver_host)' 'MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [ConnInfo] (url)

 

The target was already being monitored by the previous plugin version for SQL Server 12.1.0.3.0 and no configuration changes were done.

 

Changes

 Upgraded the MS SQL SERVER Plugin to 12.1.0.4.0

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms