Just today, I did a test installation of Management Reporter 2012 and migrated my client’s FRx reports using the migration wizard. There are quite a few useful posts out there but I ran into an issue that hasn’t been documented very well. Before running the migration wizard, be sure to prepare your data using the following support post:
While going through the migration wizard I came to the following screen, the instructional document (MRforDynERPMigrationfromFrxGuide_ENUS.pdf) said to enter the server name as a URL with the port number then choose “Test Connection” which caused my computer to hang for 10 minutes.
Here are the steps to take to get through this “Specify Connection” step in the Migration Wizard:
1. Enter the server name in the server name box such as server1, do not enter the server name in this format http://server1:4712
2. Do not choose the test connection button, otherwise you’ll get the message as seen below “Connection attempt failed. Ensure server, login credentials, and database are correct”. Also, be sure to be logged in as the same user that you used to install Management Reporter as that’s the dbo of the MR database.
3. On the database button just choose the drop-down and you’ll see all the databases for the server.
4. Then just choose the Management Reporter database and choose next. If you don’t see the databases in the drop-down then check to see you have permissions within SQL to the server.