Teradata connection issue in SAS

[sathya66]

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;

[sathya66]

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.

[gwootton]

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

[sathya66]

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

[gwootton]

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.

[SASKiwi]

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;

[sathya66]

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