Problem Note 44120: Assigning DBMS libraries might fail in SAS® Enterprise Guide®
 |  |  |  |  |
Attempting to assign a database management system (DBMS) library in any SAS client using the META engine in SAS Enterprise Guide might result in the following error:
The problem occurs if the user does not have valid credentials to the authentication domain. The META engine requires a valid credential stored in metadata that is of the same authentication domain (AuthDomain) as the DBMS server definition if the authentication type of the DBMS server definition is set to User/Password. For example, if the Oracle server definition has the authentication domain "OraAuth" associated with it, a user accessing the server must have access to an "OraAuth" login credential. If there is not access to a credential that is of the same authentication domain as the DBMS server definition, the error occurs when you assign a DBMS library associated with the server.
The error might also occur in SAS Enterprise Guide if the following conditions are true:
- The metadata server, workspace server, and DBMS server definitions all use the same AuthDomain (for example, DefaultAuth)
- One DefaultAuth credential is used to authenticate to the metadata server, workspace server, and DBMS server
- The credential is stored in the user's metadata profile without a password
To circumvent the problem in SAS Enterprise Guide, select Tools ► SAS Enterprise Guide Explorer and then select File ► Manage Logins. Highlight the User ID and select Modify. Enter the password and click OK.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft Windows Server 2003 Datacenter Edition | 4.305 | |||
| Microsoft® Windows® for x64 | 4.305 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.305 | |||||
| Microsoft Windows Server 2003 Standard Edition | 4.305 | |||||
| Microsoft Windows Server 2003 for x64 | 4.305 | |||||
| Microsoft Windows Server 2008 | 4.305 | |||||
| Microsoft Windows Server 2008 for x64 | 4.305 | |||||
| Microsoft Windows XP Professional | 4.305 | |||||
| Windows 7 Enterprise 32 bit | 4.305 | |||||
| Windows 7 Enterprise x64 | 4.305 | |||||
| Windows 7 Home Premium 32 bit | 4.305 | |||||
| Windows 7 Home Premium x64 | 4.305 | |||||
| Windows 7 Professional 32 bit | 4.305 | |||||
| Windows 7 Professional x64 | 4.305 | |||||
| Windows 7 Ultimate 32 bit | 4.305 | |||||
| Windows 7 Ultimate x64 | 4.305 | |||||
| Windows Millennium Edition (Me) | 4.305 | |||||
| Windows Vista | 4.305 | |||||
| Windows Vista for x64 | 4.305 | |||||
A fix for this issue for Base SAS 9.3_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/I22.html#44120A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#44120| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-09-12 11:37:33 |
| Date Created: | 2011-08-26 10:17:55 |