I am using SQL 2008 Analysis Server 10.0.2740.0 on a Windows 2008 R2 Enterprise 64 bit OS. I followed the instructions on setting up the msmdpump for IIS7. My IIS7 box is also a Windows 2008 R2 Enterprise 64 bit OS.
I have an Excel 2010 64 bit spreadsheet on a Windows 7 SP1 64 bit OS, that currently has this as a connection string:
Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=PointBridge;Data Source=chipbcsql08;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error
When I changed the connection string to Data Source=http://cube.mydomain.com/olap/msmdpump.dll instead of the servername of chipbcsql08 I get an Excel error dialog box: The HTTP server returned the following error: Method Not Allowed
I then click ok and get a 2nd Excel error dialog box that says: Errors in the OLE DB provider. An error occurred while loading the connection dialog box component for prompting.
Ideas on what I need to change? I think I am about to make this happen!! haha Helpful thoughts will be rgeatly aprpeciated!!
View Complete Post