ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal Installation

How to access SQL 2005 cubes via RP on SQL 2000?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
jamma	Posted - 04/05/2007 : 10:43:05 Our Report Portal is installed on a 32-bit box running SQL 2000 with the latest service pack. We're moving our DW to new 64-bit hardware running SQL 2005. I'd like to create RP reports on the current box that point to AS 2005 cube on the new servers. Anyone know how to do this? FWIW, I've followed the instructions here: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx and I can successfully connect to the new server via the MDX sample application on the old server, but if I try to connect via the XML for Analysis Setup app, I get 401 permissions errors. I've tried all sorts of logins that should be authorized. Any ideas out there?: --------------------------- XmlaSetup --------------------------- Could not connect to XMLA service: http://KEENBIG11/olap/msmdpump.dll. Please check user id and password, restart IIS and try again. --------------------------- OK ---------------------------
1 L A T E S T R E P L I E S (Newest First)
admin	Posted - 04/10/2007 : 21:21:10 There is no 64-bit XMLA SDK for AS 2000. Your options: 1) You can try to run it in WoW mode. (http://en.wikipedia.org/wiki/WOW64) 2) Use 32-bit Web server connected to 64-bit db server 3) Use AS 2005 Some references: http://groups.google.com/group/microsoft.public.data.xmlanalysis/browse_frm/thread/cbc76fe006b6a7e1/9fbd6a1dbca5e3bf?lnk=st&q=64-bit+XMLA&rnum=1#9fbd6a1dbca5e3bf http://groups.google.com/groups/search?hl=en&ie=UTF-8&oe=UTF-8&q=64-bit+XMLA

ReportPortal