When connecting to Teradata databases using SAS/ACCESS Interface to Teradata, the following error might occur:
ERROR: Teradata connection: MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway <Enter> ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS file or names database <Enter>
Causes
The problem can be caused by any of the following:
-
- The logon ID is actually invalid. Check with your Teradata Database Administrator or attempt to log on with Teradata BTEQ (Basic Teradata Query) if possible. If the login succeeds with BTEQ, check the two causes below.
-
- The logon ID is an LDAP ID and your TdgssUserConfigFile.xml file has been set up with a default mechanism of TD2. In the file, you see something similar to the following:
- Mechanism Name="TD2"
- DefaultMechanism="yes"
In this case, specify loginid@ldap or login@ldaprealmname to log on.
-
- The ID is a TD2 type login and your TdgssUserConfigFile.xml file has been set up with a default mechanism of LDAP. In the file, you see something similar to this:
Mechanism Name="ldap"
DefaultMechanism="yes"
The only resolution is to set the Mechanism Name to TD2 to allow the TD2 type logins to access Teradata.