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?
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.