After feeling pretty good about my deployment skills of Management Reporter for Dynamics GP a few weeks ago, I ran into two additional lessons learned that I wanted to share.
First, on another new deployment, I got the error shown below which says “An error occurred while creating the database. View the installation log for additional information.” This problem initially pointed me to KB 2406948 which did not provide resolution.
After several hours of troubleshooting, I found there is an issue if the defaults database locations in SQL Server are set to the root of a drive. You will want to set the default to something like the following to get it installed; C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA. My default database locations for the data and log files were indeed sitting on the H:\ and I:\ drives.
To change this property in your SQL Server Instance you need to open SQL Server Management Studio, right click on the server, and choose properties and then database settings.
When I initially got the error, I briefly considered creating the ManagementReporter database by hand, but experience tells me that would have created more headaches down the road.
The second problem I ran into with this particular deployment of Management Reporter happened when I started the FRx conversion utility. The errors reads “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
I had a suspicion that this error was related to the fact FRx uses outdated technology and I happened to be on a new install of Server 2008 R2. A knowledge base search quickly pointed me to KB 2102486.
The resolution for this Management Reporter issue was to install the Microsoft Access Database Engine Redistributable, by following the site below.
