topic Re: ERROR: Teradata connection: The UserId, Password or Account is invalid. in SAS Programming

ERROR: Teradata connection: The UserId, Password or Account is invalid.

RupaJ — Mon, 27 Jan 2020 22:16:56 GMT

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

Re: ERROR: Teradata connection: The UserId, Password or Account is invalid.

Reeza — Mon, 27 Jan 2020 22:21:07 GMT

Are you connecting from your local box or a SAS server?

Re: ERROR: Teradata connection: The UserId, Password or Account is invalid.

SASKiwi — Tue, 28 Jan 2020 00:41:36 GMT

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&docsetVersion=9.4&locale=en#p0u2ejlcqks4m9n15v0n2q8xkp5c

What SAS version are you using? The way you have to specify your userid might be one of the variations in the link

Re: ERROR: Teradata connection: The UserId, Password or Account is invalid.

RupaJ — Tue, 28 Jan 2020 12:18:41 GMT

@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.

Re: ERROR: Teradata connection: The UserId, Password or Account is invalid.

SASKiwi — Tue, 28 Jan 2020 19:06:58 GMT

@RupaJ - In that case the problem is with Teradata, not SAS if nothing has changed on the SAS side.