----Not sure if I understand when you say "have opened all ports". --- It's simple. Not all ports are opened (pointing to the SAS servers) on my workstation . Initially the one used by Metadata Server has been opened but it wasn't enough. Now I have to figure out what are the others required. It's quite complicated... I might end up asking SAS tech support But first I would like to understand a little bit this issue: how many ports are required to be opened? ... View more

Found this page with useful info: http://support.sas.com/demosdownloads/000355/readme_108274.html I am trying to access SAS data using a third party tool. ... View more

It should be straight forward ... Why is it complicated to locate those scripts? ... View more

Well, I need those SAS/CONNECT Signon scripts beside SAS interpreter (to run SAS commands). I am trying to access SAS data (read/write) using Oracle Data Integrator tool; see page 96 from http://www.oracle.com/technetwork/testcontent/oracledi-km-reference-130306.pdf I am pretty new to the "SAS World" so maybe you can share some hints related to this topic. Thanks again! ... View more

Running %put %sysget(SASROOT) I got: .... 15     %put %sysget(SASROOT); /sas/sas92/SASFoundation/9.2 .... There is no such folder on my workstation so I'd guess I have to look on the server. Those commands were executed using SAS Enterprise Guide -> Program. SAS version: 9.2 Server OS: AIX Workstation OS: XP ... View more

I ran the ones mentioned by you Now I executed the last command and I got: ..... 15     %put %sysfunc(getoption(SASSCRIPT)); (!SASROOT/misc/connect) ..... However, there is no /misc/connect folder under C:\Program Files\SAS on my workstation. Should I look on the server? ... View more

It looks that SAS/CONNECT is both licensed and installed. PROC SETINIT;RUN; Product expiration dates: ---Base Product                                                            ... ---SAS/CONNECT                                                             ... ---SAS OLAP Server                                                         ... ... PROC PRODUCT_STATUS;RUN; For SAS/CONNECT ...    Custom version information: 9.21_M2 Where should I find the (sample) scripts? Thanks! ... View more

Thanks for this hint but my question was quite different... ... View more

Thanks Haikuo! Well, I don't know how I could check that option. I just installed SAS Drivers for JDBC and SAS/CONNECT for Windows so now I have some jar files under C:\Program Files\SAS\SASDriversforJDBCandCONNECT\9.1 but no script files. ... View more

Thanks! Is there a sample script file I could re-use? Where can I find SAS/Connect scripts? Do I need to install SAS/CONNECT software? Does it come as a separate package? ... View more

Thanks for this info! Before I tried  the authentication with a specific port in connection profile and it was successfully but no luck trying to retrieve AppSrv items . Meanwhile I have opened all ports and now I can see the items under AppSrv. The challenge is to find out what specific ports do I need to keep them opened... My guess is: there are several ports required... ... View more

It looks like SAS is a "black box". This information should be transparent. ... View more

Yeah, the connectivity test was unsuccessful. ... View more

Thanks for the info! That utility - itconfig.exe - didn't help to trace the missing ports. There has to be a better way to find out what are the ports required by SAS. I was able to connect with Personal Login Manager but I can't expand the servers listed in Enterprise Guide - the error is very generic and I'm pretty sure is related to a closed port. ... View more