SAP Knowledge Base Article - Preview

1739915 - How to configure HTTP Data Pump on SQL Server 2005/2008


  • When creating an OLAP connection receive the error message:
    Failed to get connections for connection [servername] using session locale [English]
  • In Business Intelligence 4.0 we need to create HTTP Data Pump in order to create an OLAP connection from CMC.
  • There is no option in CMC to select Microsoft OLE DB Provider for Analysis services 10 to create OLAP connection based on SQL Server Analysis Services.



  • SAP BusinessObjects Business Intelligence Platform BI4.0, 4.1, 4.2
  • SQL Server 2005/2008


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2


BI4.0, sql server, 2005, 2008, iis 6, iis 7, data pump, http, xmla, olap, olap connection, AOLAP, A-OLAP, Advanced Analysis for OLAP, BI, 4.0, 4.1, 4.2, 40, 41, 42, BI4.1, BI4.2, BI40, BI41, BI42, workspace, work space, MDAS, multidimensional analysis services, MSAS, Microsoft Analysis Services, datapump ADO .NET, TCIP/IP, HTTP, IIS , KBA , BI-RA-AWB , Analysis, edition for OLAP (Web) , BI-RA-MD , OLAP Intelligence, multidimensional databases , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.