| T O P I C R E V I E W |
| todd |
Posted - 12/04/2007 : 14:32:35
Hi
i am running reportportal on an sql2k/iss w2k3 box all on one server, i have upgraded to sql2k5. what i would like to do is keep my original install on the w2k3 iis box and piont the instance of report port to the sql2k5 analysis server in stead of the sql2k server.
how do i do that with out doing a complete uninstall and reinstall of report portal..
cheers for your help
Todd |
| 5 L A T E S T R E P L I E S (Newest First) |
| marco |
Posted - 02/27/2008 : 01:21:10
Hi,
For SSAS 2000 use:
xmla/msxisapi.dll or:
http://MyOtherServer/xmla/msxisapi.dll
For SSAS 2005 use:
xmla2005/msmdpump.dll or:
http://MyOtherServer/xmla2005/msmdpump.dll or:
ReportPortal/OLAP/XmlaProxy.aspx?url=http://MyOtherServer/xmla/msmdpump.dll&id=user1&pw=password1
Best regards,
Marco
www.gmsbv.nl |
| bob |
Posted - 02/27/2008 : 00:35:02
Hi..
I am new to RP, and I have the exact situation. I need to re-confgure an existing report portal ver 1.8 which is currently pointing to a SQL 2000, to SQL 2005.
I followed your instruction but which one do I need to choose, XMLA or SQL. I have installed a newer version of RP on the SQL 2005 box.Can you advise please?
Bob |
| marco |
Posted - 12/07/2007 : 23:34:38
Hi,
In ReportPortal > Admin > Connections > Here you will see the default ReportPortal SQL and XMLA Connection. You can add here any other connection to a SQL or XMLA Database by adding the connecion string.
Marco |
| todd |
Posted - 12/06/2007 : 15:13:19
hi thanks for your comments
im really new to this
could you please show me where i do this
thanks
Todd |
| marco |
Posted - 12/05/2007 : 15:05:03
Hi,
This can be done very easy withing ReportPortal as admin. You can add connections to any other SQL database or OLAP database on or outside of the server based on SQL Server Analysis Services 2000, 2005 or 2008.
Marco
www.gmsbv.nl |
Report Portal
