Enterprise Manager Generic (MOSC)

MOSC Banner

Test Connection failed , while adding target server

edited Nov 18, 2014 10:02AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered

Hi All,

I am trying to add target SQL server in OEM 12c with Remote monitoring,  but getting below error:

Sql server pulgin : 12.1.0.2.0

Sql server version : 11.0.300

Windows version : 2008 R2, 64 bit

Test Connection failed: [_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),

I need below information , which i am confused after go through metalink ids.

1.   Under  Monitoring Database Credentials

            a. What is Database Role ? example : do i need to db_owner ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center