topic Re: How Can I Get Connected to SAS Server in SAS Data Management

How Can I Get Connected to SAS Server

Eric_Chu — Tue, 24 Nov 2015 11:45:05 GMT

I was trying to connect local client to SAS remote server. But it was always failed.

I can connect the server through SAS EG. The connection confidential is connect. But when I use these confidentials to connect through SAS Foundation. It failed.

In order to connect the server, I run code as blow:

options metaserver="pdccjd010"
metaport=8561
metauser="myusername in EG"
metapass="mypassword in EG";
signon serverv="SASApp";

It returned the information of the server, like

Server=    SASApp - Connect Server
Remote Session ID = local
ServerComponent ID = ********
Remote Host = pdccjd013.site
...........
Notify = No

Then when I executed

signon server="SASApp"   or 
signon server="SASApp - Connect Server"

It returned the error message:

ERROR: No logins found.
Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed.
Unable to retrieve the SAS/CONNECT server definition "SASApp".
Remote signon to SASApp conceled.

Is there any experts can help me to find how to pass this failure. I am not sure the problem is because of my connection code, or there are any restrictions to connect to the server.

Thanks for anyone would give help !!!

Re: How Can I Get Connected to SAS Server

LinusH — Tue, 24 Nov 2015 13:10:49 GMT

Are you sure that a SAS/CONNECT server and Connect spawner is defined in metadata?

And you have the necessary rights to access/connect to it?

Also, verify that you have SAS/CONNECT licensed on both local PC and remote server.

Re: How Can I Get Connected to SAS Server

SASKiwi — Tue, 24 Nov 2015 22:18:38 GMT

The question I have is why do you want to signon to remote SAS from local SAS when you can use EG to connect to both your local and remote SAS server through the EG connection profile?

Also it looks like your first signon was successful. What happens if you then run a test RSUBMIT:

rsubmit;

proc options; run;

endrsubmit;

Re: How Can I Get Connected to SAS Server

Eric_Chu — Wed, 25 Nov 2015 00:52:08 GMT

Thanks for your replys.

1. Are you sure that a SAS/CONNECT server and Connect spawner is defined in metadata?

I am not sure whether the Connect spawner is defined in metadata. I can connect the server through EG. Does it mean the spawner is defined?

2. And you have the necessary rights to access/connect to it?

I am not sure. How can I verify the rights to access?

3. Also, verify that you have SAS/CONNECT licensed on both local PC and remote server.

Yes. My licenses is not expired on both local PC and remote server.

Re: How Can I Get Connected to SAS Server

Eric_Chu — Wed, 25 Nov 2015 01:27:01 GMT

Thanks for your replys

Part my job is downloading data table from server to my local client. This job is regularly. I did it manually in EG with a menu way which is not very convient. Now I want to finished it automatically in a coding way. That is why I am tring to connect the server in SAS foundation. If it can finish my job in EG automatically, that is also very good. After all, EG has a more convenient interface than SAS foundation ().

In the end, I tested rsubmit. It returned the error message is :

Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.
Remote submit to UNKNOWN canceled.

Thanks again for your replys! Have a good day!

Re: How Can I Get Connected to SAS Server

SASKiwi — Wed, 25 Nov 2015 07:15:19 GMT

Your log suggests that your remote session ID is called local.

Try:

rsubmit local;

proc options;
run;

endrsubmit;

Remember that the above code should be run on your PC Foundation SAS immediately after the SIGNON statements.

Re: How Can I Get Connected to SAS Server

Eric_Chu — Fri, 27 Nov 2015 03:09:04 GMT

Thanks for your patient reply.

I tried again recently. Unfortunately it still didn't work. However, I found an expert have already talked about this issue in 2012. He wrote an EG plug-in to solve this problem.

He talked about this story in this blog below. I hope it is also helpful for you.

http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/

Thanks again for your help.

Re: How Can I Get Connected to SAS Server

SASKiwi — Fri, 27 Nov 2015 03:23:57 GMT

Cool. The only restriction with this is it runs as an EG task only so you can't do it in code.

Re: How Can I Get Connected to SAS Server

Eric_Chu — Fri, 27 Nov 2015 03:26:10 GMT

Yep. It is already very convenient for me.