| T O P I C R E V I E W |
| tres_ross |
Posted - 10/22/2010 : 14:28:39
I'm switching from SQL Server 2008 to SQL Server 2008R2. I installed the 2008R2 instance as a new server rather than upgrade and have started moving the databases from 2008 to 2008R2. I was looking for a way to do this in ReportPortal but cannot find a way. I think the settings for the initial connection are in the msmdpump.dll. Is there a way to update the connection to the new server without uninstalling and reinstalling ReportPortal? Thanks. |
| 6 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 11/05/2010 : 11:00:32
So your problem is related to connection to SSAS not with moving SQL Server ReportPortal database. Correct?
Is your msmdpump.ini pointing to new SSAS server instance?
Please try to create the new XMLA virtual directory using Application Setup (All Programs > ReportPortal > Application Setup > XMLA Setup)
|
| tres_ross |
Posted - 11/04/2010 : 18:49:31
I have two instances of SQL Server on a single machine. The default instance runs 2008 while the named instance runs 2008R2. I transferred the ReportPortal database from the 2008 default instance to 2008R2 named instance. I rebuilt my cube based on the 2008R2 instance, and now trying to connect to it using ReportPortal.
I followed the information that you gave me earlier about copying the new 2008R2 xmla directory and putting it in the wwwroot/xmla directory replacing the old 2008 xmla information. I then tested the connection to the new database, and got the error:
"Test connection failed because of an error in setting the window handle property" and then says "Test succeeded with some errors after I press continue".
Then I tried to connect to the cube in ReportPortal and receive the error "Server Error - LoadLibrary failed".
Any ideas? Thanks. |
| admin |
Posted - 11/04/2010 : 14:50:24
Are you moving Report Portal repository database to another server or are you moving your SSAS server to another database? |
| tres_ross |
Posted - 11/03/2010 : 12:34:12
Thanks for the information. This fixed part of testing of the connection, though now get
"Test connection failed because of an error in setting the window handle property"
I check Yes to continue and get Test succeeded with some errors. I'm on a 64-bit machine. I've read other posts that this can happen but should work. So I tried it under the Admin - Connections page in ReportPortal and received the error
"Server Error - LoadLibrary Failed."
Any ideas? Thanks. |
| admin |
Posted - 10/28/2010 : 07:25:18
Point C:\Inetpub\wwwroot\ReportPortal\xmla.udl to the new server. |
| marco |
Posted - 10/25/2010 : 05:01:07
steps:
ReportPortal repository in SQL Server:
you should detach en attach de reportportal sql database from sql server 2008 to sql server 2008 r2 to have the reportportal repository working.
XMLA connection:
copy the new xmla directory from SQL Server 2008R2 into the wwwroot/xmla where the old xmla from SQL Server 2008 was installed.
Marco |
Report Portal
