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.

Resolving The Problem

The likely cause of the failed login is incorrect user information. Verify that:

    • username is correct
    • password is correct
    • account is not locked on the Sybase Database

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21647242