Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Error: cannot connect to Analysis Services version


Symptoms

When attempting to deploy OLAP user rights the following error is encountered:

""

Excerpt text from error message:

Cannot connect to Analysis Services version {version no} at TimeXtender.DataManager.CubeEngine_2005.GetEngine()

 

Cause:

This error occurs when there are multiple versions of SQL Server on the same machine.

Resolution

  1. Navigate to the External SSISEngines folder along the installation path of the Jet Data Manager

    The path below is the default installation path for a 64-bit installation.

    C:\Program Files\Jet Data Manager Server\Jet Data Manager Server {version number}\ExternalSSISEngines

  2. Rename the assembly file (.dll) for the versions that apply.

    For example: if one has SQL Server 2005 and SQL Server 2014 on the same server and the OLAP cubes reside on the 2014 instance then one would rename the 2005 dll.

The Jet Data Manager will now reference the correct assembly file while deploying OLAP user rights.

Was this article helpful?
0 out of 0 found this helpful

Comments