How to add a linked Analysis server using SQL Server Enterprise Manager

To add a linked Analysis server using SQL Server Enterprise Manager

1. In SQL Server Enterprise Manager, connect to the SQL Server computer that will host the link.
   
   
2. In the tree pane, expand the Security folder to view the Linked Servers.
   
   
3. Right-click Linked Servers, and then click New Linked Server.
   
   
4. In the Linked Server Properties dialog box, type information about the linked server. The required fields are:
   • Linked Server: This is the name of the Analysis server as it is referenced in SQL Server. This name is used to identify the linked server in queries.
     
     
   • Provider Name: Select Microsoft OLE DB Provider for Olap Services 8.0.
     
     
   • Data Source: This is the host name of the computer hosting Analysis Services.
     
     
   • Catalog: This is the name of the OLAP database provided through this link.
5. Click Provider Options. In the Provider Options dialog box, select the Allow InProcess check box.

   Note  The Allow InProcess option affects all linked servers that use the OLE DB for Analysis Services provider. This option can be changed only in SQL Server Enterprise Manager.

See Also

Adding a Linked Server