Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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:

1. Log into SAS Management Console as an administrative user (such as sasadm@saspw).
2. Under the User Manager plug-in, open the properties for the SAS Trusted User.
3. Click the Groups and Roles tab.
4. 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.

5. Restart your object spawner.

Operating System and Release Information