Posts tagged ‘Quickbooks’

Unable to Open QuickBooks Data File

Several months after every QuickBooks Pro and Enterprise annual upgrade my clients run into an issue where they cannot connect to the QuickBooks database with messages indicating, the application cannot access the database, and H2020 Error, or QuickBooks is unable to open this company file due to the file being open on another computer in single user mode.  Most recently, as per the image below:

I have found over the years the solution is to open the services management console  ( services.msc )  on the server or computer hosting the data, scroll down to locate the QuickBooks service named “QuickBooksDBxx”, where xx = a number relating to the current version.  If you have installed multiple versions over the years there will be one for each year.  You want the one with the highest number. (note in the images below the changes have already been made)

Double click on the service to open the properties for that service and click on the “Log On” tab.  The radio button “This Account” will be checked, a QBDataServixeUserxx” name will be shown, and a hidden password entered.  Change to “Local System account”, click apply and close, then right click on the service and choose start. (NOTE: if you change this setting to service account and want to change back for some reason you will likely need to re-install QuickBooks)

You now need to run the “QuickBooks Database Server Manager” app from the programs menu, in the QuickBooks folder.  Under the Scan Folders tab make sure the folder that contains your data is shown  If not browse to it and select, then click the “Start Scan” button.  It should show “successful” when done and you can choose close.  Assuming you have the same issue, running this wizard before making the change above will result in “failure”.

Quickbooks Only xxMB of memory

I tried installing Intuit’s Quickbooks 2013 today on a Windows 2012 server and received a message advising; “your system has only xxxMB of memory. Quickbooks requires at least 1GB of memory.”  

image

There was most definitely lots of RAM, so fortunately a quick Google turned up the following Intuit site which indicated Quickbooks does not always detect the proper amount of RAM available on 64 bit systems, and proposed the solution below:

http://support.quickbooks.intuit.com/support/articles/SLN41834

However I will elaborate slightly…

Rather than install from a CD copy the installation files to a location on the computer, then locate the following the file;  …..\QBooks\Framework.xml   For safety sake make a copy of this file, then review the properties of the file, and remove the read only attribute, if present.

image

Next open Framework.xml with Notepad and locate the memory requirements under <MinRequirements> within the following text.

image

Change the specification from 1000MB to 0MB, save the file, and re-try your installation.

Tag Cloud