- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
1. Installed spawner (SERVER:in windows server as admin)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is a spawner running on the server?
What does telnet 123456789.maple.fg.abc.com return?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 ??
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You need to run a spawner on the server. Please see the documentation about how to set up SAS/CONNECT connections.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
1. Installed spawner (SERVER:in windows server as admin)
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