Usage Note 15394: How to read data from a Secure Socket Layers (SSL) Web server using the URL engine
When you attempt to read data from a Web site that uses Secure Socket
Layers (denoted by URLs that begin with HTTPS://), the following error message
might appear:
ERROR: SSL support not enabled.
In order to read an HTTPS URL, you must download the SAS/SECURE™ SSL
Add-in module. SSL support is not installed by default due to trade
restrictions with several countries that do not allow this protocol.
The add-in can be found at
SAS/Secure Software.
In order to access the data on a secure Web site, you must also obtain
a certificate from the site administrator of the SSL-enabled Web site.
This certificate file needs to be imported into Internet Explorer's
Trusted Root Certification Authorities following either of the two following methods.
Method 1
- Open Internet Explorer.
- Click Tools ► Internet Options ► Contents ► Certificates.
- Click Import.
- Click Next.
- Browse for the certificate file on your PC, and click Open.
- Click Next.
- Click the Place all certificates in the following store radio button.
- Browse for certificate store and select Trusted Root
Certification Authorities.
- Look over the settings, and then click Finish.
Method 2
- Open Internet Explorer.
- Open the Web site you are trying to access, (which should prompt you with a
Security Alert dialog about viewing pages over a secure connection)and then select
OK (unless you have selected not to show this window again).
A Choose a digial certificate dialog box appears.
- Select OK.
A Security Alert dialog box appears explaining that the security certificate
was issued by a company you have not choosen to trust.
- Select Yes.
The certificate dialog opens.
- Select Install Certificate. The Certificate Import Wizard starts.
- Select Next.
- On the Certificate Store, select Browse to "Place all certificates in the following store."
- In the Select Certificate Store, change the highlight from
Personal to Trusted Root Certification Authorities, and then select OK.
- Select Next at the Trusted Root Certification Authorities store prompt,
then select Finish on the Completing the Certificate Import Wizard.
- On the Security Warning, select Yes to install the certificate.
You should receive a dialog box stating that the import was successful.
- Click OK.
Note: Only sites that prompt for user credentials in a pop-up prompt box
can be accessed. The USER= and PASS= parameters will supply your
credentials to the site. For example:
options SSLCLIENTAUTH;
filename foo url 'https://www.examplecase.com/filename.dat'
user='xxxxx' pass='xxxx';
SAS still will not be able to enter Web sites that require a user ID and
password to be provided via a login form on the site.
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows NT Workstation | 9.1 TS1M0 | |
Microsoft Windows XP Professional | 9.1 TS1M0 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | |
Microsoft Windows 2000 Server | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
64-bit Enabled Solaris | 9.1 TS1M0 | |
Linux | 9.1 TS1M0 | |
HP-UX IPF | 9.1 TS1M0 | |
64-bit Enabled AIX | 9.1 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Explains how to use certificates to open a secure Web server using the URL engine.
Type: | Usage Note |
Priority: | |
Topic: | Data Management ==> Access ==> External I/O
|
Date Modified: | 2008-11-24 13:13:59 |
Date Created: | 2005-05-27 13:17:20 |