Hello,
Here is the libname that I am using to connect to Teradata from SAS.
libname td2 teradata server=abc user=rbak schema=SDB;
Now we have SSO configured for SAS enterprise guide connection and SAS access to Teradata, so we don't have to provide the teradata password for the libname. However I get "Invalid username and password error" when trying to connect to Teradata. It works fine when I supply the password.
I also verified the password by trying to directly connect to Teradata and it works fine. So what could be the reason of error when connecting from SAS?
Thanks
@Reeza - I am connecting from local box.
@SASKiwi - We are on SAS 9.4 M5. In fact my libname used to work fine before. It's just not working now after I reset my Teradata password which ideally should not matter for SAS.
@RupaJ - In that case the problem is with Teradata, not SAS if nothing has changed on the SAS side.
According to this link single signon to Teradata using Kerboros was implemented in SAS 9.4M4 and later: https://documentation.sas.com/?docsetId=acreldb&docsetTarget=p1djetrmbn53w3n0z737je0qpqt5.htm&docset...
What SAS version are you using? The way you have to specify your userid might be one of the variations in the link
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.