![]() | ![]() | ![]() | ![]() | ![]() |
User domain accounts become locked when you connect to Hive using SAS/ACCESS® Interface to Hadoop under the following conditions:
This problem occurs because Hadoop and Hive support Lightweight Directory Access Protocol (LDAP) authentication. When you connect to Hive under the conditions listed above, the SAS/ACCESS® Interface to Hadoop engine uses the current user's domain user ID. Because the password is missing, the login attempt is rejected by Hive. After three attempts, the user's domain account is locked due to active directory security rules.
Previously, SAS/ACCESS Interface to Hadoop supported the Hadoop SIMPLE Authentication method, which allowed Hive users to connect using only a user name with no password.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to Hadoop | Microsoft® Windows® for x64 | 9.46 | 9.4 TS1M6 | ||
Microsoft Windows 8 Enterprise 32-bit | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8 Enterprise x64 | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8 Pro 32-bit | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8 Pro x64 | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8.1 Enterprise 32-bit | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8.1 Enterprise x64 | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8.1 Pro 32-bit | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 8.1 Pro x64 | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows 10 | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows Server 2012 Datacenter | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows Server 2012 R2 Datacenter | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows Server 2012 R2 Std | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows Server 2012 Std | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows Server 2016 | 9.46 | 9.4 TS1M6 | ||||
Microsoft Windows Server 2019 | 9.46 | 9.4 TS1M6 | ||||
64-bit Enabled AIX | 9.46 | 9.4 TS1M6 | ||||
64-bit Enabled Solaris | 9.46 | 9.4 TS1M6 | ||||
HP-UX IPF | 9.46 | 9.4 TS1M6 | ||||
Linux for x64 | 9.46 | 9.4 TS1M6 | ||||
Solaris for x64 | 9.46 | 9.4 TS1M6 |