Problem Note 58666: Invalid user name or password errors occur when you are using SAS/ACCESS® Interface to Vertica
Invalid user name or password errors and other fatal errors occur when you connect to Vertica databases using SAS/ACCESS Interface to Vertica. The full error message is shown below:
libname vv vertica database=my-database server="my-server.com" user=lowercase-ID password=xxxxxxx;
ERROR: CLI error trying to establish connection: FATAL 3781: Invalid username or password <Enter>
The problem occurs when the user ID that is specified in the USER= parameter contains lowercase characters. The SAS/ACCESS to Vertica engine changes any lowercase characters in the user ID to uppercase characters, which makes it invalid.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Vertica | Microsoft® Windows® for x64 | 9.4_M2 | | 9.4 TS1M2 | |
| 64-bit Enabled AIX | 9.4_M2 | | 9.4 TS1M2 | |
| 64-bit Enabled Solaris | 9.4_M2 | | 9.4 TS1M2 | |
| HP-UX IPF | 9.4_M2 | | 9.4 TS1M2 | |
| Linux for x64 | 9.4_M2 | | 9.4 TS1M2 | |
| Solaris for x64 | 9.4_M2 | | 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.
Invalid user name or password errors might occur when you are using SAS/ACCESS Interface to Vertica. The problem occurs when the user ID is case sensitive, such as lowercase versus uppercase.
To resolve the problem, apply the hot fix for your release of SAS.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-08-04 16:52:08 |
| Date Created: | 2016-07-25 10:38:51 |
