Skip to content

Fusion Network

Problem:

You are hosting your quickbooks data files on a remote system either in your facility or over a vpn. You decide that to access these files it is easiest to use a mapped network drive. Quickbooks has other plans for you and says though it sees the server and the server says you are allowed to access the quickbooks data files... QuickBooks refuses to make a connection.

The cause of the problem:

Your guess is as good as mine but heres the short version of it.

QuickBooks refuses to talk to a quickbooks data file that is on a system it cannot resolve the (a) hostname for. This is even the case if you map the network drive by IP address. Quickbooks will refuse to talk to the data file and will force you to use a "real" hostname to talk to the system that your quickbooks is hosted on.

Solutions:

These range from the very simple to the slightly less simple ;)

1. If you have a domain and the quickbooks server IP never changes (is static). You can setup an "A RECORD" for the domains DNS to make it so you can talk to the quickbooks server. (Example below).

  • Log into your DNS managment account (or local dns server if you have one) and add an "A RECORD" for your quickbooks server.
  • 192.168.2.1      qbdata1.somedomain.com
  • When accessing this share go to START -> RUN and type in "\\qbdata1.somedomain.com". You will probably need to enter a username/password.
  • Once completed you can map this location as a network drive.

2. If you do not have a domain but the quickbooks server has a static IP address you can make an entry in your systems host file that will force it to resolve to a "hostname" of your choosing. (exmaple below).

  • You will need to know where the systems hostname is. On Windows XP it is here: c:/windows/system32/drivers/etc/hosts
  • You will need to add a line like the one below.
  • 192.168.1.1 QUICKBOOKS1
  • Save and exit the file.
  • When accessing this share go to START -> RUN and type in "\\QUICKSBOOKS1". You will probably need to enter a username/password.
  • Once completed you can map this location as a network drive.

3. Start up quickbooks and point it to the newly mapped drive and you will be able to open your files again!

 

Finished:

We had this problem with a brand new, fully updated copy of quickbooks 2011 Enterprise.

Really there is no excuse for this software to behave this poorly. Its 2011 and apparently according to the QB forums this was not always a problem. Not only that but the only people trying to help solve the issue on the forum are other forum members. Ive not yet found a KB article or post by an intuit employee that shows that they even see this as an problem or suggest a simple workaround like the one(s) give above.

In my professional opinion this is hardly good design and should be fixed.