ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Report Portal & SQL Server 2005

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

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by Jared[/i]
[br]I understand that Report Portal is not officially compatiable with 2005, however, am doing some of my own testing.

When I attempt to connect to an Olap database and cube (using localhost) as server name, I get the following error:

Error: Cannot connect to the server 'LOCALHOST'.  The server is either not started or too busy.

I can connect to it fine in excel using a pivot table and the server name being LOCALHOST, however can not in Report Portal.

I have ensured my Datasource file is pointing at LOCALHOST for the Analysis Server, and have ensured my XML for Analysis Services server is correct i.e. http://LOCALHOST/xmla/msxisapi.dll

I am using the correct URL: http://localhost/reportportal

SQL Server 2005 Analysis Services seems to be fine (otherwise how would I be able to connect to it via excel?)

But still I get this error.  Is this likely to be a compatibility issue, or is there some issue with my installation/configuration?

Thanks

Jared.
[/quote]

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
Jared	Posted - 06/15/2005 : 21:42:57 I understand that Report Portal is not officially compatiable with 2005, however, am doing some of my own testing. When I attempt to connect to an Olap database and cube (using localhost) as server name, I get the following error: Error: Cannot connect to the server 'LOCALHOST'. The server is either not started or too busy. I can connect to it fine in excel using a pivot table and the server name being LOCALHOST, however can not in Report Portal. I have ensured my Datasource file is pointing at LOCALHOST for the Analysis Server, and have ensured my XML for Analysis Services server is correct i.e. http://LOCALHOST/xmla/msxisapi.dll I am using the correct URL: http://localhost/reportportal SQL Server 2005 Analysis Services seems to be fine (otherwise how would I be able to connect to it via excel?) But still I get this error. Is this likely to be a compatibility issue, or is there some issue with my installation/configuration? Thanks Jared.
3 L A T E S T R E P L I E S (Newest First)
marco	Posted - 06/17/2005 : 03:27:58 Jared, Which version of SQL Server 2005 are you using April or June Release ? Regards, Marco www.gmsbv.nl
Jared	Posted - 06/16/2005 : 20:04:44 The directions in this say to create a virtual folder called XMLA, which I already have...do I just need to replace the msxisapi.dll with msmdpump.dll ???
admin	Posted - 06/16/2005 : 19:15:40 Jared, SQL Server 2005 has its own built in XMLA service. Try downloading XMLA browser for 2005 to see how this works: http://www.reportportal.com/XmlaClient2005.zip Igor

ReportPortal