Attempt to establish connection failed with security - DB2

akrzy · Post by **akrzy** » Mon Jun 26, 2006 2:29 am

Hi
I can't connect with profileStage repository on DB2.
Could you explain me where is the problem?

SQL30082N Attempt to establish connection failed with security
reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

Thank in Advance,
Anka

ArndW · Post by **ArndW** » Mon Jun 26, 2006 3:04 am

Have you been able to connect to that DB/2 instance from the command line with the same userid and password?

akrzy · Post by **akrzy** » Mon Jun 26, 2006 3:06 am

Yes, I can...

akrzy · Post by **akrzy** » Mon Jun 26, 2006 3:07 am

Yes, I can...

akrzy · Post by **akrzy** » Mon Jun 26, 2006 3:07 am

Yes, I can...

akrzy · Post by **akrzy** » Mon Jun 26, 2006 3:08 am

Sorry, for above 3 answers

I have problem with network

akrzy · Post by **akrzy** » Mon Jun 26, 2006 3:12 am

I have problem to connect with DB2 when I am using Ascential driver.

When I used the IBM DB2 ODBC driver for connection to the repository in the Connection manager instead of the "Ascential" one, this test passes, but problem moves to the phase when I want to load DataBase Meta Data (I see in the log window I'm able to read data but I'm not able to load them into repository):

6.20 14:13:10: DEMOSERVER\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: DEMOSERVER. Process ID: 400. Program ID: 6.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 23 0 Program initialization is now complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Categories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Cust_Info'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Division'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Employees'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'EmployeeTerritories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'OrderDetails'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Orders'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Organization'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Products'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Shippers'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Suppliers'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Territories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Categories'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Cust_Info'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Division'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Employees'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'EmployeeTerritories'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'OrderDetails'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Orders'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Organization'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Products'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Shippers'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Suppliers'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Territories'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 24 0 Source database meta data extracted. Starting PSDB load.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
6.20 14:13:13: Meta Data Loader Done.
Process halted due to problem(s).

ArndW · Post by **ArndW** » Mon Jun 26, 2006 3:16 am

I don't know what could be happening here. Does your UserID or Password contain `special' characters that might be causing problems in Profilestage. The import metadata looks like it might be hitting a table permissions/authority issue.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 26, 2006 6:03 am

All of those messages appeared within at most 1.5 seconds. So it does not appear that the problem is entirely within ProfileStage. Can you use the test utility for the ODBC driver to determine that you can connect successfully and get a list of tables? Can you try to import the ODBC table definitions using DataStage, and see whether the same error occurs?

akrzy · Post by **akrzy** » Mon Jun 26, 2006 6:23 am

Thank you for reply,
But I am not Premium Memeber yet and I can't see you answer...