1700823 - Why connectivity of the OLAP connection to the SQL Server Analysis cubes has been changed to XMLA from ODBO in BI4.0

Not able to connect to the SQL Server Analysis cube by providing the machine name of the SQL Server while creating the OLAP connection in BI4.0.

• Error: "Failed to get connections for connection [servername] using session locale [English]".

• SQL Server 2005/2008/2012
• SAP BusinessObjects Business Intelligence Platform BI4.0
• SAP BusinessObjects Business Intelligence Platform BI4.1
• SAP BusinessObjects Business Intelligence Platform BI4.2

xml, ole de, odbo, olap connection, connectivity, sql server analysis, cube, 4.0, AOLAP, A-OLAP, OLAP, Advanced Analysis for OLAP, BI, 4.0, 4.1, 4.2, 40, 41, 42, BI4.0, BI4.1, BI4.2, BI40, BI41, BI42, MDAS, multidimensional analysis services, MSAS, Microsoft Analysis Services, XMLA, datapump, data pump, ADO OLEDB, SSAS, IIS , KBA , BI-RA-MD , OLAP Intelligence, multidimensional databases , Problem