23 July 2018        Add to Favorites   Report

Teradata: The UserId, Password or Account is invalid

While trying to connect to Teradata, if it fails with "The UserId, Password or Account is invalid" error, ask your friend / colleague who is able to connect to run the below query to find out whats the issue with your account

select * 
from dbc.logonoff 
where logdate >= date '2018-01-01' and username = 'YourPrettyName'

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied