Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
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?
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