Install Problems with The Closer

Posted Friday, July 9th, 2010

While installing Reporting Central’s product, The Closer, we ran into an interesting problem.

After a seemingly normal install, the product started up and prompted us for the login credentials to be used to access the SQL server.  This is completely normal.  We entered the credentials, tested them successfully and clicked Accept.  The system paused for 15 seconds then returned the below error:

clip_image002

Since we were using the sa login and were confident the server name was correct, we knew that the server side of this was fine.  After a couple of quick emails to Shane Hall at Reporting Central, we found the problem:

  • In the program files directory, an XML config file is found.  The login information you enter is in this file.
  • When I tried to edit the file, I got a file permission error when saving.  The file wasn’t read only – this was a windows security issue that was not letting me edit or write a file.
  • The machine was Windows 7.  The user was a local Admin, but UAC was activated.  By default, this denied write and modify permissions to the Program Files directory in which the Closer was installed. 
  • So, Closer would collect the data for the login, but be unable to write to the config file.  When we started Closer and entered the login info, it assumed it stored it and, when the app went to use it and it wasn’t actually there, it threw the above error.

We were able to easily solve the problem by right clicking the executable and choosing “Run as Administrator”.  Everything worked just fine at that point.

As an aside, I love this product.  If you don’t own it, buy it.  Especially if you use Purchase Orders and have to deal with reconciling Accrued Purchases.

2 Responses to “Install Problems with The Closer”

  1. [...] Specht has a nice look at the solution to some Install Problems with The Closer over at DynamicsCare. He seems to like The Closer as much as I do. Published: Monday, [...]

  2. [...] and GP).  A couple of posts came out of it that you can find at the IBIS Dynamics Care site or here and here. Categories: Uncategorized Comments (0) Trackbacks (0) Leave a comment [...]

Leave a Reply

*
*