search cancel

Teradata connection: [Error 1000] [SQLState 08S01] Login failure


Article ID: 243308


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Downloaded and installed the latest TDM Portal version (with corresponding FDM version).

Upgrade the FDM, use below link to download

Upgrade Portal , use below link to download

However, the tool fails to connect to Teradata with any type of login mechanisms:

Here are the connection Parameters:

Profile Name: DWTest3
Description: ....

DBMS: Teradata

Server*  <Our Server URL>                                Port: 

Use a Specific Database: (Tried with both the options viz. Use Named database or Do not specify database

User Name*   <my userID                                     Password*    <My Password for LDAP/Non-LDAP both mechanisms>

Additional connection properties: <Tried with LOGMECH=LDAP and LOGMECH=TD2 and also without anything... it fails.

The server replies with the below message:

Failed to connect.

Failed to obtain JDBC Connection; [Teradata JDBC Driver] [TeraJDBC] [Error 1000] [SQLState 08S01] Login failure for Connection to DWTEST3.CORP.ABC.COM Fri Jun 03 15:22:37 CDT 2022 socket orig=DWTEST3.CORP.ABC.COM cid=5e7404ff sess=0 DWTEST3.CORP.ABC.COM at Method) at$2.lookupAllHostAddr( at at at at at$Lookup.doLookup( at$Lookup.getAddresses( at at at<init>( at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO( at at com.teradata.jdbc.jdbc_4.TDSession.<init>( at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>( at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection( at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection( at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection( at com.teradata.jdbc.TeraDriver.doConnect( at com.teradata.jdbc.TeraDriver.connect( at java.sql.DriverManager.getConnection( at java.sql.DriverManager.getConnection( at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager( at


Release :

Component : TDM Web Portal

Database: Teradata 16.20


Using wrong JDBC driver.


Using Teradata JDBC driver,, resolved the issue.

This JDBC driver can be downloaded from:

You must create a Teradata account to get access to the driver.