{"id":175,"date":"2012-09-16T18:11:23","date_gmt":"2012-09-16T12:11:23","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=175"},"modified":"2012-09-16T18:11:23","modified_gmt":"2012-09-16T12:11:23","slug":"sql-server-analysis-services-linking-to-other-instance-feature-is-disabled","status":"publish","type":"post","link":"https:\/\/markwheeler.com\/?p=175","title":{"rendered":"SQL Server Analysis Services Linking to Other Instance Feature is Disabled"},"content":{"rendered":"

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

Errors in the OLE DB provider.\u00a0The server returned the following, error: (Errors related to feature availability and configuration:\u00a0The ‘Linking to other instance.’ feature is disabled by the ‘ConfigurationSettingsFeatureLinkFromOtherInstanceEnabled’ configuration property.)<\/strong><\/p>\n

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.<\/p>\n

\/Microsoft SQL Server\/MSAS10_50.MSSLSERVER\/OLAP\/Config\/msmdsrv.ini<\/strong><\/p>\n

<Feature>
\n<ManagedCodeEnabled>1<\/ManagedCodeEnabled>
\n<LinkInsideInstanceEnabled>1<\/LinkInsideInstanceEnabled>
\n<LinkToOtherInstanceEnabled>1<\/LinkToOtherInstanceEnabled>
\n<LinkFromOtherInstanceEnabled>1<\/LinkFromOtherInstanceEnabled><\/strong>
\n<ConnStringEncryptionEnabled>1<\/ConnStringEncryptionEnabled>
\n<UseCachedPageAllocators>0<\/UseCachedPageAllocators>
\n<ComUdfEnabled>0<\/ComUdfEnabled>
\n<SQMSupportEnabled>1<\/SQMSupportEnabled>
\n<\/Feature><\/p><\/blockquote>\n

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.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u00a0The server returned the following, error: (Errors related to feature availability and configuration:\u00a0The ‘Linking to […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[11,1],"tags":[108],"class_list":["post-175","post","type-post","status-publish","format-standard","hentry","category-software","category-uncategorized","tag-sql-server-analysis-services"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=175"}],"version-history":[{"count":0,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/175\/revisions"}],"wp:attachment":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}