topic Re: Base sas connect to remote windows server in SAS Programming

Base sas connect to remote windows server

sidpesar — Mon, 11 Dec 2017 22:45:23 GMT

I am trying connect my local sas to remote host by using below to run on jobs on server

---------------------------------------------------------------------

LOCAL: Windows desktop

REMOTE: Windows server 2012 R2 standard

---------------------------------------------------------------------

Ping is working fine

C:\Users\xxxxxx>ping 123456789.maple.fg.abc.com

Pinging 123456789.maple.fg.abc.com [10.238.22.201] with 32 bytes of data:
Reply from 10.238.22.201: bytes=32 time=1ms TTL=123
Reply from 10.238.22.201: bytes=32 time=1ms TTL=123
Reply from 10.238.22.201: bytes=32 time=1ms TTL=123
Reply from 10.238.22.201: bytes=32 time=1ms TTL=123

Ping statistics for 10.238.22.201:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 1ms, Maximum = 1ms, Average = 1ms

---------------------------------------------------------------------

%let sashost=123456789.maple.fg.abc.com;
options comamid=TCP ;
signon sashost user="DOMAIN\USERID" passwd="XXXXXXXX" noscript;
---------------------------------------------------------------------

But encountering with error:

NOTE: Remote signon to SASHOST commencing (SAS Release 9.04.01M4P110916).
ERROR: A communication subsystem partner link setup request failure has occurred.
ERROR: The connection was refused.
ERROR: Remote signon to SASHOST canceled.

Can someone please let me know the actual procedure to connect. It will be very helpful

Re: Base sas connect to remote windows server

ChrisNZ — Wed, 13 Dec 2017 04:50:42 GMT

Is a spawner running on the server?

What does telnet 123456789.maple.fg.abc.com return?

Re: Base sas connect to remote windows server

sidpesar — Wed, 13 Dec 2017 15:14:15 GMT

Thank you so much for the reply

1. No I didnt run spawner in the HOST machine yet

2. when I run telnet 123456789.maple.fg.abc.com PORT from my desktop, blank screen appears. I hope that means "test is successful"

------------------------------------------------------------------------------------------------------------------------

When I run as below ,

%let sashost=123456789.maple.fg.abc.com 123;
options comamid=tcp remote=sashost;
signon noscript user=12345678 password=XXXXXXXXXXXX;

NOTE: Remote signon to SASHOST commencing (SAS Release 9.04.01M4P110916).
ERROR: A communication subsystem partner link setup request failure has occurred.
ERROR: Cannot read TCP socket. System message is ''.
ERROR: Remote signon to SASHOST canceled.

-------------------------------------------------------------------------------------------------------

What will be my next steps ??

Re: Base sas connect to remote windows server

ChrisNZ — Wed, 13 Dec 2017 19:56:37 GMT

You need to run a spawner on the server. Please see the documentation about how to set up SAS/CONNECT connections.

Re: Base sas connect to remote windows server

sidpesar — Wed, 13 Dec 2017 21:14:10 GMT

1. Installed spawner (SERVER:in windows server as admin)

Using http://support.sas.com/documentation/cdl/en/camref/68088/HTML/default/viewer.htm#n16h9nv381ib2fn1kuosphaiwz9b.htm

Execution:

C:\Windows\system32>"C:\Program Files\SASHome\SASFoundation\9.4\cntspawn.exe" -install
SAH201001I Server SAS Connect Spawner, State, starting

SAS Connect Spawner version 9.40 (build date: Jun 24 2015)
Copyright (C) 2011-2013, SAS Institute Inc., Cary, NC, USA. All Right
SAS Connect Spawner service was installed successfully.

C:\Windows\system32>NET START "SAS Connect Spawner"

The SAS Connect Spawner service is starting...
The SAS Connect Spawner service was started successfully.

---------------------------------------------------------------------------------

2. After SPAWNER running successful

I Executed below steps in local machine

%let sashost=123456789.maple.fg.abc.com;

options comamid=tcp remote=sashost;

signon noscript user=12345678 password=XXXXXXXXXXXX;

Log:

NOTE: Remote signon to SASHOST commencing (SAS Release 9.04.01M4P110916).
NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M3)
Licensed to XXXXXXX
NOTE: This session is executing on the X64_SRV12 platform.

NOTE: Updated analytical products:

SAS/STAT 14.1
SAS/ETS 14.1
SAS/IML 14.1

NOTE: Additional host information:

X64_SRV12 WIN 6.2.9200 Server

NOTE: SAS initialization used:
real time 0.25 seconds
cpu time 0.26 seconds

NOTE: Remote signon to SASHOST complete.

It connected succesfully