Connection to Teradata

[SCasey_Anthem]

I'm trying to run a program where the initial step connects to Teradata; however, I'm getting an error with the authdomain statement.

proc sql exec feedback stimer;

connect to teradata (authdomain=teradataauth TDPID=DWPROD2 MODE=TERADATA CONNECTION=GLOBAL); *10-26-2016;

create table dat.cancer_&client as

select * from connection to teradata (

select distinct.....

This is the start of the statement and the error is twofold:

1.  Warning: No login information was available for authdomain teradatauth...

2. ERROR:  Teradata connection: MTDP: EM_NEWCONN(207): Error in doing a network connect...

I'm using identical code that a colleague uses yet they have no issues.  Could it be something in my EG environment setup?

[JBailey]

Hi @SCasey_Anthem,

That error usually means that a Teradata client cannot connect to the server. This could be a network problem or a Teradata Tools and Utilities configuration issue. One way to troubleshoot it is to connect using the Teradata BTEQ utility (from the machine where SAS is running). 

This message is pretty old. Hopefully, this was sorted-out a long time ago.

Best wishes,

Jeff

[lisixue]

Hi@SCasey_Anthem, I know you might not need this answer anymore since it was an old thread. but I just want to help folks who search the same topic. I work for Anthem too.  

Step1:  Open Enterprise Guide and select Enterprise Guide Explorer from Tools menu.

Step 2: Click on file menu from Enterprise Guide explorer window and select “Manage login” from available options.

Step3: Click on Add button from Login Manager Window and provide details about the US domain ID and password.