Usage Note 40755: Connection errors when running a query in SAS® Information Map Studio or SAS® Web Report Studio
If SAS Trusted User (sastrust@saspw) is an unrestricted user and you are using a pooled workspace server, queries in SAS Information Map Studio and SAS Web Report Studio will fail.
For example, when attempting to run a query, you might see an error message that includes the following content, indicating that a connection to the pooled workspace server on port 8701 has been refused.
Connection refused: connect
java.net.ConnectException: Connection refused: connect
............
[ com.sas.services.connection.FatalConnectionFactoryException: The application could not
log on to the server "machine.name.com:8701". No server is available at that port on that machine.
Following is another typeof connection error that you might see in the application or the log.
ERROR [] com.sas.servlet.tbeans.valuepicker.ValuePicker -
An existing connection was forcibly closed by the remote host
In addition, the object spawner log will contain messages similar to the following, indicating that a password cannot be retrieved for the launch credentials for the pooled workspace server (typically, sassrv).
2010-09-01T10:30:06,119 INFO [00000021] SYSTEM@machine - Error authenticating user machine\sassrv in function LogonUser.
Error 1326 (Logon failure: unknown user name or bad password. ).
2010-09-01T10:30:06,119 WARN [00000021] SYSTEM@machine - The credentials specified for the SASApp - Pooled Workspace Server (A53BEC7R.AV000006)
server definition failed to authenticate. Therefore this server definition will not be included.
2010-09-01T10:30:06,120 WARN [00000021] SYSTEM@machine - The password obtained from the metadata indicates
that it was obtained by an user that has unrestricted access. Please check your configuration.
To resolve this problem, perform these steps:
- Log into SAS Management Console as an administrative user (such as sasadm@saspw).
- Under the User Manager plug-in, open the properties for the SAS Trusted User.
- Click the Groups and Roles tab.
- Edit the SAS Trust User's memberships so that he is not a member of any of the following groups or roles.
- SAS Administrators
- Metadata Server:Unrestricted
- Metadata Server:User Administration
Note: You must also ensure that the SAS Trusted User is not an indirect member of any group or role with unrestricted privileges.
- Restart your object spawner.
Operating System and Release Information
SAS System | SAS Information Map Studio | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
Windows Vista | 4.2 | | 9.2 TS2M0 | |
Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
SAS System | SAS Web Report Studio | z/OS | 4.2 | | 9.2 TS2M0 | |
Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
Windows Vista | 4.2 | | 9.2 TS2M0 | |
Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
64-bit Enabled AIX | 4.2 | | 9.2 TS2M0 | |
64-bit Enabled Solaris | 4.2 | | 9.2 TS2M0 | |
HP-UX IPF | 4.2 | | 9.2 TS2M0 | |
Linux for x64 | 4.2 | | 9.2 TS2M0 | |
Solaris for x64 | 4.2 | | 9.2 TS2M0 | |
*
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.
Type: | Usage Note |
Priority: | |
Topic: | System Administration ==> Security ==> Authentication System Administration ==> Security ==> Identity Management System Administration ==> Security ==> Roles
|
Date Modified: | 2010-09-01 11:22:37 |
Date Created: | 2010-09-01 10:14:10 |