Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 463

11. Deploy the project to move the metadata to the Analysis Services in-
stance (localhost\I2).
12. For both localhost and localhost\I2 do the following in SSMS:
1. Connect to the service.
2. Right-click the instance name, and select Properties.
3. Change the Value (first column) of both
Feature\LinkToOtherInstanceEnabled and
Feature\LinkFromOtherInstanceEnabled to True.
4. Click OK to close the Analysis Servier Properties dialog. To
make these changes stick, you need to restart the instance
of Analysis Services; just right-click the instance name in
Object Explorer and click Restart and click Yes when asked
for verification.
13. In BIDS, create a second data source in the Adventure Works DW
project to connect to the subordinate (target) instance of Analysis
Services, and specifically at the target project (named Target here).
Use the Native OLE DB\ Microsoft OLE DB Provider for Analysis
Services 9.0 (see Figure 9-66 ) .