Base sas connect to remote windows server

[sidpesar]

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

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

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

[ChrisNZ]

Is a spawner running on the server?

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

[sidpesar]

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 ??

[ChrisNZ]

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

[sidpesar · Accepted solution]

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

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

 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