Usage Note 57679: A "Name not in HOSTS file or names Database" error occurs when you are using SAS/ACCESS® Interface to Teradata
 |  |  |  |
When issuing a LIBNAME statement to connect to Teradata, you might see the following error:
Name not in HOSTS file or names database
The problem occurs even when the machine name is in the HOSTS file for the operating system. The problem occurs when there is a firewall between the machine running SAS® and the Teradata machine and only one port is open.
To resolve the problem, add the port after the server name in the SERVER= parameter of the LIBNAME statement. The syntax is shown below, using port 1521:
libname test teradata server='my-server:1521' user=my-user password=my-password
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft Windows 8 Pro x64 | ||
| Microsoft Windows 8 Pro 32-bit | ||||
| Microsoft Windows 8 Enterprise x64 | ||||
| Microsoft Windows 8 Enterprise 32-bit | ||||
| Microsoft® Windows® for x64 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | ||||
| Microsoft Windows 8.1 Enterprise x64 | ||||
| Microsoft Windows 8.1 Pro | ||||
| Microsoft Windows 8.1 Pro 32-bit | ||||
| Microsoft Windows 10 | ||||
| Microsoft Windows 95/98 | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows Server 2003 for x64 | ||||
| Microsoft Windows Server 2008 | ||||
| Microsoft Windows Server 2008 R2 | ||||
| Microsoft Windows Server 2008 for x64 | ||||
| Microsoft Windows Server 2012 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Std | ||||
| Microsoft Windows Server 2012 Std | ||||
| Microsoft Windows XP Professional | ||||
| Windows 7 Enterprise 32 bit | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Home Premium 32 bit | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Professional 32 bit | ||||
| Windows 7 Professional x64 | ||||
| Windows 7 Ultimate 32 bit | ||||
| Windows 7 Ultimate x64 | ||||
| Windows Millennium Edition (Me) | ||||
| Windows Vista | ||||
| Windows Vista for x64 | ||||
| 64-bit Enabled AIX | ||||
| 64-bit Enabled HP-UX | ||||
| 64-bit Enabled Solaris | ||||
| ABI+ for Intel Architecture | ||||
| AIX | ||||
| HP-UX | ||||
| HP-UX IPF | ||||
| Linux | ||||
| Linux for x64 | ||||
| Solaris | ||||
| Solaris for x64 | ||||
When attempting to connect to Teradata, you might receive a "Names not in HOSTS file" error. The problem occurs when there is a firewall between SAS and Teradata and there is only one port open. To resolve the problem, add the port number to the server specified in the server=parameter.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2016-03-07 10:56:00 |
| Date Created: | 2016-02-17 11:58:51 |