SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sidpesar
Obsidian | Level 7

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
sidpesar
Obsidian | Level 7

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

 

 

 

 

 

View solution in original post

4 REPLIES 4
ChrisNZ
Tourmaline | Level 20

Is a spawner running on the server?

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

 

 

sidpesar
Obsidian | Level 7

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
Tourmaline | Level 20

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

 

sidpesar
Obsidian | Level 7

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

 

 

 

 

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 4466 views
  • 1 like
  • 2 in conversation