SQL30082N Attempt to establish connection failed with security reason "3" ("PASSWORD MISSING"). SQLSTATE=08001
 Technote (troubleshooting)
 
Problem(Abstract)
The TestConnection button fails with the following SQL Exception; you might have the same problem with the application using the data source.

Exception stack trace from the SystemOut:

[7/30/04 16:37:31:480 EDT] 534421e0 DSConfigurati W DSRA8201W:
DataSource Configuration: DSRA8041I: Failed to connect to the
DataSource. Encountered SQLException with SQL State = 08001, Error Code
= -30,082 : [IBM][CLI Driver] SQL30082N Attempt to establish connection
failed with security reason "3" ("PASSWORD MISSING"). SQLSTATE=08001
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Attempt to
establish connection failed with security reason "3" ("PASSWORD
MISSING"). SQLSTATE=08001

at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExcepti
onGenerator.java:192)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptio
nGenerator.java:423)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:531)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:436)
at
COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(DB2ReusableConnection.
java:74)
at
COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(DB2PooledConnection.j
ava:188)
at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfig
urationHelper.java:1736)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
 
Cause
J2C Authentication Alias is not set for the v5 data source or a password is not set for the v4 data source.
 
Resolving the problem
Make sure you are providing the password for the data source through the J2C Authentication Alias or through custom property Password.

Providing the user ID and password for the v5 data source through the custom properties UserName and Password is not recommended.


Instructions for creating the J2C Authentication Alias and setting to the datasource:

Java 2 Connector authentication data entry settings

Follow these instructions to define authentication data, which includes user identities and passwords. These authentication data entries can be referenced by resource adapters, data sources and other configuration objects that require authentication data using an alias.

  1. Click Security > JAAS Configuration > J2C Authentication Data Entries.

  2. Click New to define a new authentication data entry.

  3. Enter the ID and password and save the changes, then go the Data source

  4. Click Resources > JDBC Providers > JDBC_provider > Data Sources > data_source

  5. Select Component-managed Authentication Alias or Container-managed Authentication Alias, then save the changes.

  6. Restart the Server and then click Test Connection, or try to run the application that uses the data source.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.1.1
Software edition:
Reference #: 1175923
IBM Group: Software Group
Modified date: Aug 16, 2004