| Author |
 Topic  |
|
|
AMM
Poland
2 Posts |
 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? |
|
|
admin
1645 Posts |
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? |
 |
|
|
AMM
Poland
2 Posts |
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? |
Edited by - AMM on 07/20/2006 01:16:15 |
|
|
|
admin
1645 Posts |
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. |
|
|
| |
Topic |
|
|
|
Report Portal
Problems after transfer
