title: Creating a linked server in SQL Server 2012 for analysis services with the connection string consisting of the instance name
body: <p>I was creating a linked server from SQL database to Analysis services using the server ip along with the instance name. While doing so I got the following error: </p>
  
  <blockquote>
    <p>Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "TEST".
    OLE DB provider "MSOLAP" for linked server "TEST" returned message "Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '<strong><em>*</em>**<em>*</em>*</strong>' server.".
    OLE DB provider "MSOLAP" for linked server "TEST" returned message "Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '<strong><em>*</em>**<em>*</em>*</strong>' server.".</p>
  </blockquote>
  
  <p>So I created an alias for the server along with the instance name. After doing so got the error below:</p>
  
  <blockquote>
    <p>Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "TEST".
    OLE DB provider "MSOLAP" for linked server "TEST" returned message "The following system error occurred:  The requested name is valid, but no data of the requested type was found. ".</p>
  </blockquote>