Whenever I try to open XL Reporter it hangs while connecting and then throws the error:
"Unable to connect to XL Reporter. Error! Server communication failed!
Cause: Server (local)
The connect information provided in MetaInfo.xml is wrong.
(Please contact the administrator to change ChangeDbPassword."
I am using Windows Vista and have Office 2007. I have checked the box "Trust access to the VBA project object model" in Trust Center Settings.
I removed the client completely, deleted the XLR folder and reinstalled. Same error. I opened the ConnectionManager.exe in the XLR folder. I can't connect there with (local) as the db. If I change it to my machine name\SQLEXPRESS then I connect. However, when I go back to open XL Reporter from within Business One, I get the same error.