ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal Installation
 New xmla connection to SQL SERVER 2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sh1n

Indonesia
21 Posts

Posted - 11/18/2009 :  23:15:05  Show Profile  Reply with Quote
Hi, I have a running Report Portal 3.0 with SQL Server 2000. And now I want to make an xmla connection to SSAS. The problem is I'm stuck... Can anyone help me with a step by step explanation ?

marco

Netherlands
588 Posts

Posted - 11/18/2009 :  23:47:28  Show Profile  Reply with Quote
Hi,

Just follow the steps:

http://technet.microsoft.com/en-us/library/cc917711.aspx

And in ReportPortal > Admin add a new SSAS connection to SSAS 2005, SSAS2008 or SSAS2008R2

Regards, Marco

www.gmsbv.nl
Go to Top of Page

Sh1n

Indonesia
21 Posts

Posted - 11/19/2009 :  00:22:11  Show Profile  Reply with Quote
Marco:And in ReportPortal > Admin add a new SSAS connection to SSAS 2005, SSAS2008 or SSAS2008R2

Did you mean in Admin->Connections->Type->SSAS or Type->XMLA URL ?

Edited by - Sh1n on 11/19/2009 01:14:42
Go to Top of Page

marco

Netherlands
588 Posts

Posted - 11/19/2009 :  05:54:27  Show Profile  Reply with Quote
Hi,

XMLA URL

http://www.reportportal.com/help/architecture.htm

Marco

www.gmsbv.nl
Go to Top of Page

Sh1n

Indonesia
21 Posts

Posted - 11/20/2009 :  00:56:57  Show Profile  Reply with Quote
It still won't work. Is there anything to set on the SQL Server 2005 ? I'm also a newbie in using 2005.

Edit : I've solved it, the problem is I haven't installed the AS OLE Driver... Once I installed it I could use Start Menu -> All Programs ->Report Portal -> Application Setup to set up the connection.


Edited by - Sh1n on 11/20/2009 01:58:02
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page