I have now been stuck on this one for some time - this is OEM12.1.0.5 with the MSSQL plugin trying to monitor a remote MSSQL database using windows authentication.
I have a windows Agent running fine with the plugin installed. Now I am trying to connect to the database so it can be monitored using an LDAP authenticated user and password.
I can RDC to the MSSQL's box using these credentials, and from there into the database using windows authentication, the user in the database has the correct authorities.
I have checked and dont believe there are any blocked ports (1433) from the agent to the remote MSSQL.
When I run a test connection - after a few seconds (maybe 30 or so) I get a screenful of errors such as below
com.microsoft.sqlserver.jdbc.AuthenticationJNI GenerateClientContext WARNING: com.microsoft.sqlserver.jdbc.AuthenticationJNI@3f6dadf9 Authentication failed code : -2146892976 Jun 21, 2018 3:04:03 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI SNISecGenClientContext WARNING: InitializeSecurityContext failed with -2146892976{WINERR}. Jun 21, 2018 3:04:03 PM
To me this looks like some sort of authentication failure but I cannot work out exactly where the problem is.
I know next to nothing about LDAP and my windows knowledge is pretty minimal.
Any suggestions on where to look next gratefully received