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.
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
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".
Report Portal
Changing Database Servers on Same Server
Posted - 10/22/2010 : 14:28:39
