Shared Memory Connection Attempt Error | CLEARIFY

Shared Memory connection attempt error

You open up Excel, invoke the Excel Add-In the first time, and receive this 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 "Remote Connection" under Advanced Options>Database.

MULTI-USER (CLIENT)

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