2517152 - How to solve error "Login failed" when you attempt to login to SAP IQ Cockpit after changing host name

Symptom

You may want to change host name that IQ database and SAP IQ Cockpit ware installed. When you changed host name to new one, IQ database and SAP IQ Cockpit would start fine.
However you may not able to login to SAP IQ Cockpit with error "Login failed" even if you specify correct UserName and Password.
You will find the below error in agent.log file under $SYBASE/COCKPIT-4/log (%SYBASE%\COCKPIT-4\log).

[INFO ] [security.IQLoginModule] [RMI TCP Connection(13)-127.0.0.1] - Validating credentials
[ERROR] [security.IQLoginModule] [RMI TCP Connection(13)-127.0.0.1] - java.sql.SQLException: JZ006: Caught IOException: java.net.UnknownHostException: OLD_HOSTNAME
[ERROR] [security.IQLoginModule] [RMI TCP Connection(13)-127.0.0.1] - Login failed

Environment

SAP IQ 16.0 SP08 or later

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

Validating credentials, java.sql.SQLException, JZ006, java.net.UnknownHostException, hostname , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.