ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Problems after transfer

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 AMM[/i]
[br]Hello!

The situation looks like this: there are 3 machines: A, B and C. The all run under Windows 2003. They all have their LAN addresses (192.168.1.0) and external IP addresses (NAT).
A has IIS and ReportPortal installed and configured, everything runs smoothly.
B has an instance (AMM4K) of SQL Server 2005 and Analysis Services (running of port 2415) installed and is housing the the ReportPortal database.
C also has an instance of SQL Server 2005 and Analysis Services (running on port 2415) installed.
Now, what I wanted to do, was to transfer the ReportPortal database from machine B to machine C. So, I detached the ReportPortal database, moved it from B to C and attached it there. Then, I turned off the B machine and added B's IP address (192.168.1.156) to C.
Then, I went to the ReportPortal URL, entered the login information and what I got was this:
[url]http://img146.imageshack.us/my.php?image=rpinstancemz1.png[/url]

Why is that? I don't know. The IP of Analysis Services has not changed, the Analysis Services TCP port has not changed, the location of XMLA has not changed (A), the sa password has not changed, ReportPortal site has not been moved... When I give B his IP back, ReportPortal starts working fine again.
So, the question is this: what's missing in C's configuration? In configuration of which service?
[/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
AMM	Posted - 07/17/2006 : 06:26:37 Hello! The situation looks like this: there are 3 machines: A, B and C. The all run under Windows 2003. They all have their LAN addresses (192.168.1.0) and external IP addresses (NAT). A has IIS and ReportPortal installed and configured, everything runs smoothly. B has an instance (AMM4K) of SQL Server 2005 and Analysis Services (running of port 2415) installed and is housing the the ReportPortal database. C also has an instance of SQL Server 2005 and Analysis Services (running on port 2415) installed. Now, what I wanted to do, was to transfer the ReportPortal database from machine B to machine C. So, I detached the ReportPortal database, moved it from B to C and attached it there. Then, I turned off the B machine and added B's IP address (192.168.1.156) to C. Then, I went to the ReportPortal URL, entered the login information and what I got was this: [url]http://img146.imageshack.us/my.php?image=rpinstancemz1.png[/url] Why is that? I don't know. The IP of Analysis Services has not changed, the Analysis Services TCP port has not changed, the location of XMLA has not changed (A), the sa password has not changed, ReportPortal site has not been moved... When I give B his IP back, ReportPortal starts working fine again. So, the question is this: what's missing in C's configuration? In configuration of which service?
3 L A T E S T R E P L I E S (Newest First)
admin	Posted - 07/24/2006 : 06:13:38 To test if A can connect to the Analysis Services on B and C you can use another UDF file that uses "Microsoft OLE DB Provider for OLAP" Or you can go to: Programs > ReportPortal > Application setup.
AMM	Posted - 07/20/2006 : 00:48:43 OK. Opened xmla.uml, changed IP address, clicked on Test Connection and everything went well, as you can see here: [url]http://img154.imageshack.us/img154/4695/xmlatestek7.png[/url] That way I can test if A can connect to the SQL Server service, am I correct? How do I test if A can connect to the Analysis Services on B and C?
admin	Posted - 07/18/2006 : 17:20:12 Please open xmla.udl (C:\Inetpub\wwwroot\ReportPortal\xmla.udl) and point it to Machine C. Click the �Test Connection� button. What do you see?

ReportPortal