topic Re: Connecting outside Virtual Environment in SAS Enterprise Guide

Connecting outside Virtual Environment

edmb — Wed, 02 Mar 2016 23:21:20 GMT

Hi,

I'm trying to connect to my SAS server outside the virtual environment, hosted by our Citrix Server, by using a standalone version of Enterprise Guide (7.1). However, when I connect to the SAS metadata server in SAS EG 7.1 and expand "SASMain" to see the libraries, I'm timed out and the below error is returned.

Could not establish a connection to the server on the requested machine. Verify that the server has been started and that the host and port of the server match the client's connection information.

-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
Message:         Could not establish a connection to the server on the requested machine. Verify that the server has been started and that the host and port of the server match the client's connection information.
Source:          SAS.EG.SDS.Model
Target Site:     SASWorkspace

Stack Trace:
at SAS.EG.SDS.Model.Server.SASWorkspace()
at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op)

Inner Exception Details:
----------------------------------------
Exception type: SAS.EC.Directory.Model.SDSException
Message:         Could not establish a connection to the server on the requested machine. Verify that the server has been started and that the host and port of the server match the client's connection information.
Source:          EC.Directory
Target Site:     Connect

Inner Exception Details:
----------------------------------------
Exception type: System.Runtime.InteropServices.COMException
Message:         Could not establish a connection to the server on the requested machine. Verify that the server has been started and that the host and port of the server match the client's connection information.
Source:          SASObjectManager
Target Site:     CreateObjectByLogicalNameAndLogins

Stack Trace:
at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByLogicalNameAndLogins(String Name, Boolean synchronous, Object pIOMI, String LogicalName, LoginDef pOMRLoginDef, LoginDef pSASLoginDef, String nameValuePairs)
at SAS.EC.Directory.Model.Server.Connect(ConnectionInfo connInfo)

Re: Connecting outside Virtual Environment

SASKiwi — Thu, 03 Mar 2016 02:05:43 GMT

So you can connect to your metadata server OK and you see in the Server List SASMain? Is this correct? Normally its called SASApp but I think it can be customised.

The errors suggest that it is the request to start a Workspace Server session on your SAS Application server is failing.

What user credentials are you supplying in your EG connection? Is it your username and password or are you using IWA?

It would help to check the Workspace Server log for further errors relating to your connection. To do this work would need to be able to remotely log on to the server.

Re: Connecting outside Virtual Environment

edmb — Thu, 03 Mar 2016 08:43:11 GMT

Hi,

That is correct. I can connect to the metadata server okay (I believe, since I can see SASMain and also Shared Folders and the tables in Shared Folders - yet unable to open either).

When using the virtual environment I first supply my Active Directory username and password to log in to the Citrix server and then load the virtual SAS EG where I connect to the SAS metadata server by entering my UNIX LDAP username and password.

When using my standalone SAS EG, I just supply the metadata server and my UNIX LDAP username and password - and the above error is returned.

Is there a way to check the Workspace Server log in the standalone SAS EG?

Re: Connecting outside Virtual Environment

SASKiwi — Thu, 03 Mar 2016 18:58:01 GMT

Unfortunately you cannot access the Workspace Server log from EG. It is stored on a SAS Application Server drive so you would normally have to log on to the server to view it. Do you have a SAS Administrator who can check this out for you?

Since your SAS servers run on Unix its a bit harder to check out whats happening on them.

My best guess at this point is that EG is trying to establish a SAS Workspace Server session on your SAS App server and failing. One area to look at are firewall rules. Typically servers these days are set up behind firewalls and there may need to be a rule change for a non-Citrix Workspace Server connection to happen. Again a SAS Admin or your server support folks should be able to help.

Re: Connecting outside Virtual Environment

edmb — Fri, 04 Mar 2016 16:32:38 GMT

Thank you SASKiwi, my company's SAS admin team are now going to look into it, at last! I shall pass them on your comments. Many thanks 🙂