Problem Note 54851: EM_NOHOST(224): errors might occur when you connect to Teradata using SAS/ACCESS® Interface to Teradata
When connecting to Teradata databases using SAS/ACCESS® Interface to Teradata, you might receive the following error messages:
ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.
ERROR: Error in the LIBNAME statement.
The error messages typically indicate that the machine name is not found in the Teradata hosts file on the SAS server. The problem also occurs when the Teradata user ID is being used for the first time or when an existing Teradata user ID has an expired password. Teradata passwords cannot be reset by SAS.
To resolve the problem, log on to the Teradata server using the Basic Teradata Query (BTEQ) utility from Teradata to test your connection. BTEQ prompts you to change your password when logging on to the system. The new password should be used in your LIBNAME statement or PROC SQL code to connect to Teradata.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for x64 | 9.4 TS1M2 | |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M2 | |
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M2 | |
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M2 | |
| Microsoft Windows 8 Pro x64 | 9.4 TS1M2 | |
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M2 | |
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M2 | |
| Microsoft Windows 8.1 Pro | 9.4 TS1M2 | |
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M2 | |
| Microsoft Windows Server 2008 | 9.4 TS1M2 | |
| Microsoft Windows Server 2008 R2 | 9.4 TS1M2 | |
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M2 | |
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M2 | |
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M2 | |
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M2 | |
| Microsoft Windows Server 2012 Std | 9.4 TS1M2 | |
| Windows 7 Enterprise 32 bit | 9.4 TS1M2 | |
| Windows 7 Enterprise x64 | 9.4 TS1M2 | |
| Windows 7 Home Premium 32 bit | 9.4 TS1M2 | |
| Windows 7 Home Premium x64 | 9.4 TS1M2 | |
| Windows 7 Professional 32 bit | 9.4 TS1M2 | |
| Windows 7 Professional x64 | 9.4 TS1M2 | |
| Windows 7 Ultimate 32 bit | 9.4 TS1M2 | |
| Windows 7 Ultimate x64 | 9.4 TS1M2 | |
| 64-bit Enabled AIX | 9.4 TS1M2 | |
| 64-bit Enabled Solaris | 9.4 TS1M2 | |
| HP-UX IPF | 9.4 TS1M2 | |
| Linux for x64 | 9.4 TS1M2 | |
| Solaris for x64 | 9.4 TS1M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
When you use SAS/ACCESS Interface to Teradata with a new user password, SAS® generates an "MTDP: EM_NOHOST(224): name not in HOSTS file" or names database" error. The problem might occur because of a new (first use) user password setting in the user's account in Teradata.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-01-28 09:41:15 |
| Date Created: | 2014-12-15 12:53:29 |
