"Attempted to read or write protected memory. This is often an indication other memory is corrupt" might occur in SAS® clients


The following error can occur in SAS® Enterprise Guide 8.6 or SAS® Add-in 8.6 for Microsoft Office if you use the connection profile to make a connection to SAS® Metadata Server. (Specifically, after you install SAS Add-in 8.6 for Microsoft Office, the following error can occur in SAS Add-in 8.6 for Microsoft Office if you use the connection profile to make a connection to SAS® Metadata Server in Microsoft Excel, Microsoft Word, or Microsoft PowerPoint.)

                Unable to connect to the Metadata Server    A connection could not be established to a SAS Metadata Server running on port XXXX on host XXXXXXXX.    Server Response: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

This SAS Add-in 8.6 for Microsoft Office error occurs with older versions of Microsoft Office and Office 365, such as, but not limited to, the following:

Note: To locate the Microsoft Excel version information, complete the following steps:

  1. Open a blank Microsoft Excel workbook.
  2. Click File. Then, select Account (or More ► Account).
  3. View the Product Information details in the right pane. Then, click the About Excel box to view the entire version and bitness of Microsoft Excel.

Hot Fix

To fix the error for SAS Enterprise Guide 8.6 and SAS Add-in 8.6 for Microsoft Office, apply the hot fix. This fix works for SAS Add-in 8.6 for Microsoft Office with the currently installed, older version of Microsoft Office or Office 365. This hot fix also works with an updated Microsoft Office or Office 365 version.

The hot fix for this issue updates the SAS® Integration Technologies client component that SAS Enterprise Guide 8.6 and SAS Add-in 8.6 for Microsoft Office use to make the connection to SAS Metadata Server. 

Workaround

SAS Add-in 8.6 for Microsoft Office: Upgrade to a Newer Microsoft Office or Office 365 Version

If you do not apply the hot fix, a possible workaround for the SAS Add-in 8.6 for Microsoft Office issue is to upgrade the current Microsoft Office or Office 365 version to a newer version (or the latest version). This error does not typically occur when you upgrade to newer versions, such as, but not limited to, the following: