topic Re: Teradata connection issue in SAS in Administration and Deployment

Teradata connection issue in SAS

sathya66 — Wed, 12 Jan 2022 13:17:16 GMT

Hi All,

User is getting below ERROR . He has correct user ID and password and updated through SAS logon manager.

Even tried with TD user ID and password in the libname but no luck. Tried in TD sql assistant with same ID and password and it worked.

libname test teradata user=<user_ID> password=”password” database=test fastload=yes;

libname test teradata AUTHDOMAIN="TeradataAuth" database=test fastload=yes;

Re: Teradata connection issue in SAS

sathya66 — Wed, 12 Jan 2022 14:24:47 GMT

User has special char (double quote) in the TD password. like Pass"31. is it with password?

how can we make it work as TD sql assistant is accepting this password but not through SAS.

Re: Teradata connection issue in SAS

gwootton — Wed, 12 Jan 2022 14:46:47 GMT

If you attempt a connection with a password without that particular special character, does it work as expected?

Re: Teradata connection issue in SAS

sathya66 — Wed, 12 Jan 2022 15:30:15 GMT

Yes, it is working without particular special character (like ! ",etc)

Re: Teradata connection issue in SAS

gwootton — Wed, 12 Jan 2022 15:35:46 GMT

You may wish to engage SAS Technical Support then, to ensure this is not an issue with the Teradata engine. For the LIBNAME statement including the user/password I could see how a double-quote could raise an issue if you were also using double-quotes to enclose the password (as in your first post example), but if it's stored in an AUTHDOMAIN I would expect this to be properly handled.

Re: Teradata connection issue in SAS

SASKiwi — Wed, 12 Jan 2022 23:44:14 GMT

If you are testing the connection like this:

libname test teradata  user=<user_ID> password=”password” database=test fastload=yes;

Then try single quotes around the password string. BTW even your double quotes don't look right as they should look like this: "

libname test teradata  user=<user_ID> password='password' database=test fastload=yes;

Re: Teradata connection issue in SAS

sathya66 — Mon, 17 Jan 2022 09:47:26 GMT

Double quotes looks right.Tried with single quotes as well. raised with SAS. Update you once I get back from them.