Shared Memory Connection Attempt Error | CLEARIFY

Shared Memory connection attempt error

You open up Excel and invoke the Excel Add-In the first time, and receive the following message:

Message from Excel PowerPivot:

NOTE: this can also occur when getting an error message trying to use the Microsoft Access shells from the Configuration Tool

Cause

There are two methods of communicating with the QQube database:  (1) Memory Pools, or (2) TCP/IP.  There are certain applications for which Memory Pools do not work, and there are occasions where Excel is not happy with this arrangement. There is no negligible effect on usability regardless of option. 

Resolution

SINGLE-USER 

Check the "Disable Shared Memory" under Advanced Options>Database.

VERSIONS 7.X:

VERSIONS 5.6X THRU 6.X:

MULTI-USER 

VERSIONS 7.X:

'Disable Shared Memory' is disabled by default on the Client User, and is not necessary to disable on the server.

VERSIONS 5.6X THRU 6.X:

'Disable Shared Memory' needs to be disabled on both the client and the server.