How to add SSAS Analysis Services as a linked server to SQL server

We can set up a linked server for SSAS Analysis Services using following steps:

  • Connect to the Database Engine in SQL 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 below:
    • Provider: Microsoft OLE DB Provider for Analysis Services 10.0 or 11 (SSAS 2012)
    • Product name: MSOLAP.4 or MSOLAP(SSAS 2012)
    • Data source: (the name of SSAS server)
    • Catalog: (the name of the SSAS database)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s