AM Integration: Test Connection Failed:ODBC error: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLSTate: IM006

  • KM03659461
  • 29-Jun-2020
  • 22-Oct-2020

Summary

Caused by: Error (12,001): ODBC error: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLSTate: IM006

Error

 

<2019-09-27 10:00:36,960> [ERROR] [Dashboard Thread] (ProbeTasksDistributerPull.java:964) - Failed connecting to server (is server down?)

<2019-09-27 14:53:34,685> [ERROR] [AdHoc:AD_HOC_TASK_PATTERN_ID-491-1569569467872] (FederationNoneLifeCycleProbeProcessor.java:72) - Failed executing none life cycle federation request [com.hp.ucmdb.discovery.probe.request.TestConnectionProbeRequest] for integration [AM Push]

 

com.hp.amadapter.push.exception.AMPushAdapterException: Test ConnectionFailed

at com.hp.amadapter.AMPushAdapter.testConnection(AMPushAdapter.java:80)

at com.hp.ucmdb.adapters.GenericAdapter.callPushConnectorToTestConnection(GenericAdapter.java:166)

Caused by: java.lang.reflect.UndeclaredThrowableException

at com.sun.proxy.$Proxy80.startTransaction(Unknown Source)

at com.hp.amadapter.AMPushAdapter.testConnection(AMPushAdapter.java:65)

... 35 more

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

... 37 more

Caused by: Error (12,001): ODBC error: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLSTate: IM006

ODBC: Unable to connect to database 'AMDS-aaeae94289123854fa2e154e4' (UserId='sa')

Unable to connect to this database engine.

 

at com.peregrine.ac.api.AmApi96JNI.AmGetConnection(Native Method)

at com.peregrine.ac.api.AmApi96.AmGetConnection(AmApi96.java:155)

 

Cause

Wrong DB name

Fix

Use the correct DB name