BookmarkSubscribeRSS Feed
apolodor
Calcite | Level 5

How can I find out what ports my SAS client is using to connect to a SAS Server (Metadata)?

I was able to connect/log in using SAP Enterprise Guide but I got an error while expanding Server List items.

Thank you!

21 REPLIES 21
Amir
PROC Star

Hi,

Posting the error message and/or a screen shot of the issue, might help someone provide an answer.

Does the following document help?:

http://support.sas.com/techsup/technote/ts790.pdf

There are many references to "port" in it as well as some default values.

Regards,

Amir.

apolodor
Calcite | Level 5

Thanks for the info! That utility - itconfig.exe - didn't help to trace the missing ports.

There has to be a better way to find out what are the ports required by SAS.

I was able to connect with Personal Login Manager but I can't expand the servers listed in Enterprise Guide - the error is very generic and I'm pretty sure is related to a closed port.

connection_error.jpg

Amir
PROC Star

Hi,

So I guess the section on page 9 of the PDF was not relevant / does not apply to your case or does not tell you the port numbers you want:

SAS required ports - PDF extract.png

Regards,

Amir.

apolodor
Calcite | Level 5

Yeah, the connectivity test was unsuccessful.

Amir
PROC Star

Hi,

Then in that case, I'd recommend you get in touch with SAS Technical Support (link at bottom of page) who should be able to help you with your specific issue.

Regards,

Amir.

apolodor
Calcite | Level 5

It looks like SAS is a "black box". This information should be transparent.

Haikuo
Onyx | Level 15

I doubt it is a port problem, unless during the deployment, your SAS admin purposely made some change. Ask your Admin to verify if object spawner is running as a service on your Appserver, and if your credential is permitted to access Appserver on OS level (on Windows server local security setting, your credential should be able "act as part of operation system", and "able to run batch jobs").  If you just try to figure out port number in your connection profile, just open the profile and check it out. In EG, the active connection profile is on the right bottom corner, click to open it, then you will see:

_1.JPG

_2.JPG

Similar connection profiles can also be found in Management Console, Olap cube studio, information map studio , Microsoft add-ins and other clients.

apolodor
Calcite | Level 5

Thanks for this info!

Before I tried  the authentication with a specific port in connection profile and it was successfully but no luck trying to retrieve AppSrv items .

Meanwhile I have opened all ports and now I can see the items under AppSrv. The challenge is to find out what specific ports do I need to keep them opened... My guess is: there are several ports required...

Haikuo
Onyx | Level 15

Not sure if I understand when you say "have opened all ports".

Well, there are several steps when doing the connection, knowing the anatomy will help to understand the problem, take workspace server for example:

1. When you launch a connection request using a client in SAS EBI environment, you first connect to Metadata server, in the case showed above, the port is 8561

2. Then the metadata server searches the metadata to retrieve the name of the machine hosting the workspace server, the port on the which the object spawner listens for requests for this server, and the authentication domain info. This connect information will then be return to your clients.

3. Your client (EG) will then make the request for the a workspace server using the information obtained from metadata server.

4.The object spawner will verify your credentials and launch the workspace server.

5. TCP connection is completed.

So from your description, it seems to me that the connection info stored in your metadata (Profile_A) is NOT matching the configuration reality of your Appserver (Profile_B). If you have Management console, you can  find out "Profile_A" easily by going to plug-ins, then server manager. For "Profile_B", you need to access the machine that hosts your Appserver, and locate objectspawner.bat and some other Config files which define the initiation process of objectspawner and other server service, such as Workspace server, storeprocess server etc.

However, frankly if I were you, I would have involved SAS tech support long time ago.

Haikuo

apolodor
Calcite | Level 5

----Not sure if I understand when you say "have opened all ports". ---

It's simple. Not all ports are opened (pointing to the SAS servers) on my workstation . Initially the one used by Metadata Server has been opened but it wasn't enough. Now I have to figure out what are the others required.

It's quite complicated... I might end up asking SAS tech support

But first I would like to understand a little bit this issue: how many ports are required to be opened?

ChrisHemedinger
Community Manager

For the minimum setup for connection between SAS Enterprise Guide and your environment behind a firewall, the answer is two:

- one port for the SAS Metadata Server (by default, 8561)

- one port for the SAS Workspace Server (by default, 8591)

If you have a stored process server, you will also need a port for that (8601 by default).

You need to open the ports only for server resources that EG will connect to directly, where it acts as the client endpoint.  There are other ports in play, but many are "SAS to SAS" connections that will be in the same "zone" and probably won't be governed by the firewall that is affecting EG.

Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
canmjs
Calcite | Level 5

Hey Chris,

 

Thank you for your post on this - very helpful and saves alot of navigation through documentation.  Now, with SAS 9.4M3 the default pooled workspace server appears to be 8701.  Is this correct?

 

Marc

 

ChrisHemedinger
Community Manager

Yes, it looks that way.  All of the default ports are documented in the Install Guide.


Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
rf_mikael
Fluorite | Level 6

Chris, 

I am forwarding port 8561 on the SAS server to a port on my local machine via Bitvise SSH and then pointing EG to the local port. 

However, it looks like I also need to forward 8591 as well, which I can do, but then how do I point EG to the local port?

Does EG has a config file somewhere in C:\Program Files\SASHome\SASEnterpriseGuide\7.1 ?

 

Will it work if both ports are forwarded and pointed to?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 21 replies
  • 8991 views
  • 3 likes
  • 7 in conversation