IBM Support

Guardium Datasource connecting to Sybase fails with error SqlState: 01ZZZ Error Code: 4002 SQLWarning: 010HA

Troubleshooting


Problem

You are trying to set up a Datasource to connect IBM Security Guardium to your Sybase database. When testing the connection it fails with this error msg: com.guardium.dbSource.DataSourceConnectException: Could not connect to: 'jdbc:sybase:Tds::8543/master' for user: 'SYBASE_USER(Security Assessment)'. DataSourceConnectException: Could not connect to: 'SYBASE SYBASE_USER :8543' for user: 'sqlguard'. SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s). SqlState: JZ00L Error Code: 0 SQLWarning: Login failed. SqlState: 01ZZZ Error Code: 4002 SQLWarning: 010HA: The server denied your request to use the high-availability feature. Please reconfigure your database, or do not request a high-availability session. SqlState: 010HA Error Code: 0 SQLWarning: Login failed. SqlState: 01ZZZ Error Code: 4002 SQLWarning: 010HA: The server denied your request to use the high-availability feature. Please reconfigure your database, or do not request a high-availability session. SqlState: 010HA Error Code: 0

Symptom

This error msg talks about high-availability, but this is a misleading error msg returned from the Sybase database.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.2","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21647242