Solved

DB2 Connection failure

Posted on 2003-10-21
8
524 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
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…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

21 Experts available now in Live!

Get 1:1 Help Now