Unable to attach to the remote instance

singhipst · #1 (**permalink**) 05-12-10, 01:23

Hi,

I am getting below error while attaching to the remote instance.

Code:

D:\Backups>db2 attach to P6APP1_1 user db2inst1
Enter current password for db2inst1:
SQL30082N  Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID").  SQLSTATE=08001

D:\Backups>

This command is failing in windows XP however i am able to catalog node using control center by search option and it is able to search the db2 instance running on AIX and databases runinng under this instance.

The password and user name are correct and the same command (user/password) is working fine in AIX machine where my DB2 Server is running.

Below is the dbm configuration on my DB server running on AIX

Code:

 Database manager authentication        (AUTHENTICATION) = SERVER
 Alternate authentication           (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
 Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
 Trust all clients                      (TRUST_ALLCLNTS) = YES
 Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
 Bypass federated authentication            (FED_NOAUTH) = NO

Environment Details:
SERVER OS : AIX 64 bit
DB SERVER :9.7 with Fix Pack 1

CLIENT OS : Windows XP
CLIENT DB : 9.7 Fix Pack1

ARWinner · #2 (**permalink**) 05-12-10, 08:22

As the error states, either the username or password is incorrect.

Andy

n_i · #3 (**permalink**) 05-12-10, 08:50

There may be problems with passwords that are longer than 8 characters and/or contain punctuation characters. Try a password that's no longer than 8 alphanumeric characters.

singhipst · #4 (**permalink**) 05-13-10, 00:44

i used password as db2inst1 only

ARWinner · #5 (**permalink**) 05-13-10, 08:06

Can you connect to a database on the AIX server form windows?

Andy

dr_te_z · #6 (**permalink**) 05-13-10, 10:38

please post the result of

Code:

db2 list node directory

singhipst · #7 (**permalink**) 05-14-10, 05:10

D:\>db2 list node directory

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = P6APP1_1
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = TESTDBSRV
Service name = db2c_db2inst1

D:\>

Internet Services

Web Development

Digital Marketing

Consumer Tech