Teradata]User identification is not authorized error

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
alexcol
Participant
Posts: 17
Joined: Mon Feb 28, 2011 8:52 am

Teradata]User identification is not authorized error

Post by alexcol »

Good afternoon
I need yor help because i havent been able to Connect to Tearadata using ds command shell:

connect Teradata_Pro
Enter username for connecting to 'Teradata_Pro' DBMS [dsadm]: dsadm
Enter password for dsadm:
SQLConnect error: Status = -1 SQLState = S1000 Natcode = -3004
[ODBC:-3004] [IBM(DataDirect OEM)][ODBC Teradata Client driver][Teradata]User identification is not authorized.

checking out the 3 ODBC config files files ie in dsenv file there is an entry calling the userbd and passwd called dsadm:

PATH=$PATH/opt/teradata/client/13.0/bin
export ORACLE_HOME=/oracle/product/10.2.0
export ORACLE_SID=xmeta
PATH=$PATH:/oracle/product/10.2.0/bin
export PATH=$PATH:/datastage/IBM/InformationServer/ASBNode/apps/jre/bin
export USERBD=dsadm
export PASSBD=dsadm

Acording to these 2 last lines this is not the authorized user and passwd?
But in the .odbc.ini file theres no information provided with the user and paswd:

[Teradata_Pro]
Driver=/datastage/IBM/InformationServer/Server/branded_odbc/lib/VMtera23.so
Description=DataDirect Teradata
CharacterSet=ASCII
DBCName=10.80.4.20
#Database=SQL_gaguirre
EnableDataEncryption=No
EnableLOBs=Yes
EnableReconnect=No
IntegratedSecurity=No
LoginTimeout=20
MapCallEscapeToExec=No
MaxRespSize=8192
#Password=SQL_gaguirre
PortNumber=1025
PrintOption=N
ProcedureWithSplSource=Y
ReportCodePageConversionErrors=0
ShowSelectableTables=Yes
#UserID=SQL_gaguirre
ALEJO
Post Reply