Ansicht
Dokumentation

SQ30082 - Authorization failure on distributed database connection attempt. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Vendor Master (General Section)  
This documentation is copyright by IBM.


Message : SQ30082
Authorization failure on distributed database connection attempt.

Message Long Text :

Cause . . . . . : A connection attempt failed with reason code &2. The reason codes and their meanings are as follows:
0 -- Unknown cause.
1 -- Password expired.
2 -- Password not valid.
3 -- Password missing.
4 -- Protocol violation.
5 -- User ID not found.
6 -- User ID not valid. For a DB2 for IBM i server, this could mean a damaged user profile or PASSWORD(*NONE).
7 -- User ID revoked or disabled.
15 -- Security processing at the server failed.
16 -- The new password is not valid.
17 -- The security mechanism requested by the client is not supported or allowed at the server. See recovery information below.
22 -- Security processing at the client failed.
23 -- CCSID conversion of the password failed.
Recovery . . . : Correct the problem indicated by the reason code, if possible, and attempt to connect again. A common cause for reason code 17 is that the server requires a password, but because the client does not have a password to send, sends only a user ID. Or, the server requires an encrypted password and the client did not send an encrypted password. A password can be supplied by the user in two ways:
1 -- By using the USER ... USING ... clause on the SQL CONNECT statement, or
2 -- By using the ADDSVRAUTE CL command to add a server authorization entry for the remote server under the user's profile. The server name (DRDA RDB NAME) must be entered in upper case.
The DRDA server can be configured with the CHGDDMTCPA CL command to not require a password, or to not require an encrypted password.

Message File : QSQLMSG
Library Message File : QSYS2924


PERFORM Short Reference   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3279 Date: 20240510 Time: 162050     sap01-206 ( 3 ms )