search

ibmdb / vscode-extension

vscode extenstion for db2 as db2connect
7 stars 2 forks source link

Connection to database failed: Error: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 #46

Closed hoangtony21184 closed 2 years ago

hoangtony21184 commented 2 years ago

So I have installed DB2 following this instruction: https://ajstorm.medium.com/installing-db2-on-your-coffee-break-5be1d811b052

However, I could not connect to DB2 via the VSCode extension with the following error

Connection to database failed: Error: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

Please help, thank you :)

bimalkjha commented 2 years ago

@hoangtony21184 What is the output of db2level command? Are you able to connect to Db2 server using any other client? This error tells either the userid or password is incorrect. If you have any special character in password, then enclose it between single quote and try. Thank.

bimalkjha commented 2 years ago

Closing the issue due to inactivity. We can reopen it once you share the requested info. Thanks.