Archive for

Creating a Linked Server for Analysis Services

  To set up a linked server for Analysis Services, follow these steps: Connect to the Database Engine in Management Studio. Expand Server Objects, right-click Linked Servers, and click New Linked Server. Define a name for the linked server, and set the following options as shown in the screenshot below: Provider: Microsoft OLE DB Provider … Continue reading