Tuesday, November 15, 2011

Connection authorization failure occurred. Reason: User ID or Password invalid.

If you get below mentioned error


Exception in thread "main" com.ibm.db2.jcc.b.bo: [jcc][t4][2013][11249][3.53.95]
 Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
        at com.ibm.db2.jcc.b.bd.a(bd.java:674)
        at com.ibm.db2.jcc.b.bd.a(bd.java:60)
        at com.ibm.db2.jcc.b.bd.a(bd.java:120)
        at com.ibm.db2.jcc.t4.b.o(b.java:2018)
        at com.ibm.db2.jcc.t4.b.c(b.java:1646)
        at com.ibm.db2.jcc.t4.bb.r(bb.java:793)
        at com.ibm.db2.jcc.t4.bb.k(bb.java:349)
        at com.ibm.db2.jcc.t4.bb.c(bb.java:133)
        at com.ibm.db2.jcc.t4.b.Oc(b.java:1271)
        at com.ibm.db2.jcc.t4.b.b(b.java:1192)
        at com.ibm.db2.jcc.t4.b.B(b.java:5098)
        at com.ibm.db2.jcc.t4.b.c(b.java:750)
        at com.ibm.db2.jcc.t4.b.b(b.java:693)
        at com.ibm.db2.jcc.t4.b.a(b.java:376)
        at com.ibm.db2.jcc.t4.b.(b.java:312)
        at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)
        at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:224)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)


As the error suggest, The login credentials are not matching. Please make sure that user name and password are correct.

Also check for correct URL. Make sure that all login credentials are correct.