Frist check these setps:
The hosts file is not set up properly.
DNS is not set up properly.
Source Link for Winsock Error Code List
There are two types to connect to database or user in SQL assistant
1. Just Connect to tdadm then write DATABASE <USERNAME>; and execute.
2. if you want to connect to database then u have to create user in ODBC driver
--> Open ODBC Data source Administrater then Click SYSTEM DNS then Click ADD then scroll down and select Teradata and click Finish. and One Box Open. edit Like user_name, password and Name of IP Address (127.0.0.1) and click OK. then open SQL Assistant and you can choose the what have you done before than connect to the user or database