Skip to Content
0
Former Member
Jun 04, 2008 at 02:32 AM

MII 11.5 OLAP Connector

39 Views

I am trying to connect MII 11.5 to SQL Server 2005 Analysis Services via the Microsoft OLAP connector.

I have setup the HTTP pump for SSAS [as found on the MS TechNet|http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx] and I can connect to the resulting web service via http://SERVER/olap/msmdpump.dll in a web browser, so I presume that the HTTP setup is correct.

I have tried various combinations of settings in the OLAP connector in MII: Key differences (I think) from the default include setting DataSourceInfo = "Provider=MSOLAP.3;Data Source=http://" and Web Service="/olap/msmdpump.dll".

Each configuration that I try, though, results in a error: "Server is currently disabled (OLAPConnector)."

Does the OLAP connector support SSAS 2005? If so then are there unique connection parameters required? If not then is there a workaround?