Usage Note 39718: A "Teradata connection" error occurs when you the Lightweight Directory Access Protocol (LDAP) with SAS/ACCESS® Interface to Teradata
 |  |  |  |
In the second maintenance release for SAS® 9.2 (TS2M2), the following error occurs when you use the LDAP with SAS/ACCESS Interface to Teradata:
LIBNAME myconn teradata USER="your–id@LDAP" PASSWORD=password TDPID=your–server;
ERROR: Teradata connection: MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway.
ERROR: Teradata connection: MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway.
The problem occurs because the LDAP logon might not recognize realms in SAS/ACCESS Interface to Teradata.
To circumvent the problem, add the authentication domain to the user ID, as shown below:
libname myconn teradata user="your-id@LDAPactive-directory-domain"
password=password tdpid=your-server;
password=password tdpid=your-server;
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for x64 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Home Premium 32 bit | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Home Premium x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 9.2 TS2M2 | 9.2 TS2M3 | ||
The "MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway" error can occur when you use LDAP connections to Teradata with a single realm using Active Directory services. To circumvent the problem, add the Active Directory Domain to the LDAP ID.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2010-11-08 15:00:27 |
| Date Created: | 2010-05-21 12:30:20 |