About nhvdwalt

nhvdwalt · ‎07-02-2018

Hi @EdM Unfortunately our project timelines didn't allow us to complete the investigation, so no resolution was found.

nhvdwalt · ‎06-14-2018

@RupaJ Check out this SAS Note. I've found it very useful in the past to troubleshoot authentication issues. http://support.sas.com/kb/39/891.html

nhvdwalt · ‎06-14-2018

@RupaJ Are you 100% sure the userid & password used in the SDW is the same you use for the direct log on ?

nhvdwalt · ‎06-14-2018

@itareque 1.) Which version of SAS are you using ? 9.4 ? 2.) Are you using SAS Access to MS-SQL Server, SAS Access to ODBC or another method as described by @ChrisHemedinger ? 3.) Do you connect to a SAS server ? If so, which OS ? Linux or Windows ?

nhvdwalt · ‎06-13-2018

@itareque Below are the system requirements for SAS 9.4. Select the OS on which your SAS deployment runs e.g. Linux and then look at the requirements for the particular SAS/Access engine you are using e.g. SAS/Access to MS-SQL Server When in doubt, always contact SAS Technical Support https://support.sas.com/en/search.html?q=*%3A*&fq=siteArea%3A%22System%20Requirements%22&fq=releasesystem%3A9.4&fq=product%3A%22SAS%2FACCESS%20Interface%20to%20Microsoft%20SQL%20Server%22

nhvdwalt · ‎05-16-2018

I'm not quite following the problem.... If you try and access the URL using Chrome, what error do you get ? Have you tried with IE or Firefox perhaps ?

nhvdwalt · ‎05-15-2018

Hi @LJalaja 1.) What internet browser are you using ? If Chrome, then you must ensure the CN of the server certificate also appears in the list of SANs for the server certificate 2.) Also, make sure the full CA chain is imported into your Windows certificate store. 3.) Open up each certificate in your CA chain from the Windows certificate store and ensure that every certificate is ok. Maybe the new certificate was signed with a chain of CAs and one of the CA (s) is missing from the certificate store. 4.) You can even import the new server certificate into the Windows certificate store and check that it validates ok

nhvdwalt · ‎05-08-2018

Thanks @SimonDawson Do you know in what version this option was introduced ? I'm not finding it in my 9.4 deployment.

nhvdwalt · ‎04-24-2018

In short, it means your workspace server session has crashed. The trick is to find out why... I guess there are different ways to troubleshoot, but my approach would be to run the code in batch on the server, thus removing things like SAS Enterprise Guide, Workspace Servers, etc. out of the equation. When the SAS session then crashes again, you should receive a lot more diagnostic information than what you do in Enterprise Guide. Based on this info you can then investigate further.

nhvdwalt · ‎03-26-2018

Another consideration is your shared file system. Can your file system live across different OSs ? Some file systems might require that all nodes are 100% identical.

nhvdwalt · ‎03-24-2018

We've also encountered this a couple of times. Unfortunately, usually due to time constraints, we have to skip this step and try and investigate later. Would be keen to see the outcome here.....

nhvdwalt · ‎03-08-2018

No problem. Also search the web for SAS Papers on the topic, there are many good papers out there with some solid examples.

nhvdwalt · ‎03-08-2018

100%, then you will of course specify the HTTPS URL in PROC HTTP. Just make sure that the needed CA certificates are installed on SAS. Have a look at the SAS guide titled 'Encryption in SAS 9.4' that will tell you where and how these certs are stored in the SAS installation.

nhvdwalt · ‎03-08-2018

My knowledge of mainframe SAS is zero. However you access web services with either PROC HTTP or PROC SOAP, depending on the type of web service. If those procs are available on the mainframe, then I guess you could....

nhvdwalt · ‎03-06-2018

It will be on the Compute server

Online Status	Offline
Date Last Visited	‎01-09-2023 09:54 AM

Re: Azure Data Lake | How to access

Re: SAS Licensing on Docker

Re: SAS Licensing on Docker

Re: Remove site number from sas metadata

Re: We have SAS 9.4 and Viya Clusters --- What is the best way to Guid...

Re: CLOSE_WAITS increase causing WEBAPP server latency

Re: CLOSE_WAITS increase causing WEBAPP server latency

Re: Core license compliance

Re: Rapid 7 Vulnerabilities- Apache Tomcat

Re: Migrating form SAS 9.4 M4 to SAS Viya.

An Insider's Guide to SAS and Database Support Information

Sneak Preview - SAS/ACCESS Interface to Google BigQuery

Sneak Preview - SAS/ACCESS Interface to Snowflake

Re: SAS Patches

Re: SAS Patches

Re: X command for sasgsub

Re: Error while importing a file

Re: Reference of previous hostname prevents to upgrade to 9.4TS1M5

Re: Reference of previous hostname prevents to upgrade to 9.4TS1M5

Re: Azure Data Lake | How to access

Re: Enable HTTPS for SAS Environment Manager

Re: SAS 9.4 M5 Metadata configuration Error

Re: SAS 9.4 M5 Metadata configuration Error

Re: Is SAS EG 7.1 compatible with SQL 2016?

Re: Is SAS EG 7.1 compatible with SQL 2016?

Re: SSL certificate renewal failed for SAS Web servers

Re: SSL certificate renewal failed for SAS Web servers

Re: PROC HTTP with insecure SSL certicates

Re: Error while importing a file

Re: SAS Grid - several operating systems

Re: SAS 9.4M5 Configuration with SSL - ERROR: "failed to create initia...

Re: Can we access web services from Mainframe sas? Or is there another...

Re: Can we access web services from Mainframe sas? Or is there another...

Re: Can we access web services from Mainframe sas? Or is there another...

Re: ODBC SERVER in Linux