Solved

DB2 Connection failure

Posted on 2003-10-21
8
523 Views
Last Modified: 2008-03-04
Hi Experts,

     Previousely  I've tried to connecting (AIX based) DB2 databases from my linux box thru perl module were sucessful, but when try to connect (Win based) DB2 database I'm getting the following errors.

    "TLMA" is my DB2 db.
 
       "SQL1403N  The username and/or password supplied is incorrect.  SQLSTATE=08004"

Here are my configurations :-

  Database Directory List :-

      $ db2 list database directory
                  Database alias                     = TLMA
                  Database name                   = TLMA
                  Node name                         = TLMA
                  Database release level         = 9.00
                  Comment                           =
                  Directory entry type             = Remote
                  Catalog node number          = -1

  Node Listing :-

      $ db2 list node directory

                  Node name                       = TLMA
                  Comment                         =
                  Protocol                           = TCPIP
                  Hostname                        = 172.20.80.84
                  Service name                   = 50000

     I feel I'm not connected with the above error, but I don't know where the error lies on. I'm Sure the username and password are correct.

Plz. Help me on this.
Click.
 
 
0
Comment
Question by:clickrajkumar
8 Comments
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9597340
Your logged on userid is not authorised to connect to the database.

Try these commands from the db2 shell.

d:> db2cmd

e:> db2 connect to "yourdatabase" user "youruserid" using "yourpassword"

The default DB2 installation on a winnt machine only grants access rights to the local administrator
on the machine i.e the "administrator" userid.

If you are logged on via an NT domain log off the domain, log back on to the local machine as
"administrator"(you must know the password). Once logged in either add your domain userid to the
LOCAL administrators group or create a new local id for yourself. If you choose the former you can
access DB2 from the domain, choose the latter and you must log on locally to the machine to access
DB2. Once you have administrator rights you can add domain users to DB2 group objects and restrict
access rights.
0
 

Author Comment

by:clickrajkumar
ID: 9597501
Hi,

   I'm trying to Connect DB2 database in a Win2000 Server and 'm having myown userid (other than Administrator) which has proper access privileges.

   I've tried connecting to the DB thru DB2 Connect from my Linux Box it throws the following.


[db2inst1@AAA db2inst1]$ db2 connect to TLMA user db2 using db2admin
SQL1403N  The username and/or password supplied is incorrect.  SQLSTATE=08004
[db2inst1@AAA db2inst1]$

   Even I'm getting the same error when try to connect by my perl module.

  What I've to do more on this???

Click
0
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9597569
As far as I know, you need an account with Administrator access for this. Is your account in this kind?
0
 

Author Comment

by:clickrajkumar
ID: 9597709
Yep Fantasy,

   I've also tried with both (As by my userid aswell as with Admin id), Still the same problem is choking my neck.

Click
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 5

Expert Comment

by:fantasy1001
ID: 9597753
From others sources:

Check the ownership and permissions on the db2ckpw program. They should look like this:
bash$ ls -al ~/sqllib/security/db2ckpw
-rwsr-s--x    1 root     build       15989 Oct 17 07:22 sqllib/security/db2ckpw*
 
If this program is not owned by root, then do the following as root:
bash# chown root db2ckpw
bash# chmod ug+s db2ckpw
 
0
 

Author Comment

by:clickrajkumar
ID: 9597897
Yes Fantasy,
   I've read same answer from IBM site itself, and when I try to search for db2ckpw file in the 2000 Server (Win) Machine I was unable to get it. It seem the above soluiton is only fit for Linux Flavoured Servers...

Click
0
 
LVL 20

Expert Comment

by:jmcg
ID: 10030553
Nothing has happened on this question in over 2 months. It's time for cleanup!

My recommendation, which I will post in the Cleanup topic area, is to
PAQ, refund points (unanswered, but some interesting steps along the way).

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer
0
 

Accepted Solution

by:
SpazMODic earned 0 total points
ID: 10078697
PAQed, with points refunded (50)

SpazMODic
EE Moderator
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now