various shenanigans.

SQL Server Analysis Services Linking to Other Instance Feature is Disabled

This is related to my previous post on cloning VMs. I was not able to connect to the Analysis Server and Synchronize (cubes) between databases because of the following error.

Errors in the OLE DB provider.┬áThe server returned the following, error: (Errors related to feature availability and configuration:┬áThe ‘Linking to other instance.’ feature is disabled by the ‘ConfigurationSettingsFeatureLinkFromOtherInstanceEnabled’ configuration property.)

Msmdsrv.ini the following path is the configuration file in the system directory. Set “LinkFromOtherInstanceEnabled” property to TRUE (1) and save and restart analysis service.

/Microsoft SQL Server/MSAS10_50.MSSLSERVER/OLAP/Config/msmdsrv.ini

<Feature>
<ManagedCodeEnabled>1</ManagedCodeEnabled>
<LinkInsideInstanceEnabled>1</LinkInsideInstanceEnabled>
<LinkToOtherInstanceEnabled>1</LinkToOtherInstanceEnabled>
<LinkFromOtherInstanceEnabled>1</LinkFromOtherInstanceEnabled>

<ConnStringEncryptionEnabled>1</ConnStringEncryptionEnabled>
<UseCachedPageAllocators>0</UseCachedPageAllocators>
<ComUdfEnabled>0</ComUdfEnabled>
<SQMSupportEnabled>1</SQMSupportEnabled>
</Feature>

That may work in some cases, you will still might the error. It’s best just to delete all your cubes and Synchronize between databases from scratch. I did have a few cubes that still did not want to behave well. In fact, trying to Synchronize them crashed the Analysis Services service. For those troublesome cubes, I simply re-dployed with BIDS.

 

Close Bitnami banner
Bitnami