Connecting to Analysis Services

Connecting to Analysis Services

Posted by: mitchmcbride on 14 September 2017, 6:34 pm EST

• 

  mitchmcbride

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 6:34 pm EST

  [activereports_archive]Hi,

  I am trying to create a data source that connects to Analysis Services 2008 R2. This is what it looks like in Reporting Services:
  
  [xml]
  
  <DataSource Name="test">
  
  <ConnectionProperties>
  
  <DataProvider>OLEDB-MD</DataProvider>
  
  <ConnectString>Data Source=OLAP1\OLAP1;Initial Catalog=TEST</ConnectString>
  
  <IntegratedSecurity>true</IntegratedSecurity>
  
  </ConnectionProperties>
  
  <rd:SecurityType>Integrated</rd:SecurityType>
  
  <rd:DataSourceID>63e6a1ce-ea93-4caf-b655-bba30aa28c05</rd:DataSourceID>
  
  </DataSource>
  
  [/xml]

  There doesn’t appear to be an OLEDB-MD provider option available when creating a data source in ActiveReports 7, so I am trying to configure it with OLAP.4. Here is my connection string:

  integrated security=SSPI;initial catalog=TEST;persist security info=True;data source=OLAP1\OLAP1;provider=MSOLAP.4;
  

  When I validate the data source I get the following message:

  The connection to the data source could not be opened.  Additional information: 'Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQL Browser service is running on OLAP1 server.
  

  Has anyone else had luck connecting to Analysis Services 2008 R2?

  Thanks,
  
  Mitch[/activereports_archive]

• 

  mitchmcbride

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 6:34 pm EST

  [activereports_archive]For some reason the OLAP provider can’t resolve OLAP1\OLAP1, although SSMS can and Reporting Services can. I was able to connect using an IP address. Will troubleshoot further.[/activereports_archive]

• 

  tuhina

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 6:34 pm EST

  [activereports_archive]Hi Mitch,

  Unfortunately, as of now, there is no official support for Analysis Services with ActiveReports. AR has not been tested with Analysis Services because of which we cannot predict its behavior with the same.

  I regret the inconvenience caused to you. You may however use the services to populate system data objects and bind your report to those objects at Runtime.

  Best Regards,
  
  Tuhina[/activereports_archive]

• 

  stan

  • Post Options:
  • Link
    Copy

  Posted 22 December 2017, 1:01 pm EST

  Any change in Active Reports supporting connections to Analysis Services Tabular?