Solved

QuickBooks 13: The company file is located on another computer and QuickBooks cannot contact that computer

Posted on 2013-02-05
13
3,263 Views
Last Modified: 2013-02-14
We are running QB 2013, and the company file is on a data drive on a Windows Server 2003. I scanned the directory and the file shows up in the DB Manager window. I checked the QuickBooksDB23 service is running and is set to Automatic. The user is also given Full Access to the QB DB shared folder as well. One of the workstations (Windows 7) can only login in single user mode, but can not change to multi user mode. When attempting to change to multi user it gets the error:

Problem: The company file is located on another computer and QuickBooks cannot contact that computer. Error code: H202.
Solution: Fix the hosting setup. Recommended: On the computer where the file is located, verify that QuickBooks is set up to host multi-user access.

I can ping the server. The workstation's windows firewall is off. Other workstations have no problem connecting using multi user mode.

One other thing, the Windows Firewall on the server is off as well.

Also on the workstation with this problem, going to File -> Utilities, I can see the option to "Host Multi-User Access", so that means it's not trying to host the file.

I feel like I checked everything. What else can it be?
0
Comment
Question by:pzozulka
  • 7
  • 6
13 Comments
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 38856797
0
 
LVL 8

Author Comment

by:pzozulka
ID: 38857561
Yep, followed all those steps short of running QuickBooks file doctor.
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 38857992
Do you have it working now?
0
 
LVL 8

Author Comment

by:pzozulka
ID: 38860202
No still the same problem. I am trying to avoid using the QuickBooks file doctor on the server. I will try using it on the workstation, but not on the server since it works for all other users.
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 38860743
from the server do this  open command prompt type net share

on computer open command prompt type net share //servername

Post results

does the share that the database files show on the computer?
0
 
LVL 8

Author Comment

by:pzozulka
ID: 38866544
From the workstation:

This shared resource does not exist.

More help is available by typing NET HELPMSG 2310.

Also, the attached image is from the workstation showing that the Q drive is mapped via DFS share to the server (i1whlnet02).

From the server:

Share name        Resource                                             Remark

-------------------------------------------------------------------------------
print$                    C:\WINDOWS\system32\spool\drivers
                                                                                                Printer Drivers
E$                           E:\                                                          Default share
prnproc$              C:\WINDOWS\system32\spool\PRTPROCS

C$                           C:\                                                          Default share
ADMIN$               C:\WINDOWS                                    Remote Admin
IPC$                                                                                       Remote IPC
F$                           F:\                                                          Default share
QuickBooks Enterprise Data
                                E:\QuickBooks Enterprise Data
Accounting         IP_10.0.24.3       Spooled               Accounting
BatchRoom01    IP_10.0.24.21    Spooled               Batch Room 01
Checks2               IP_10.0.24.5       Spooled                Checks2
Collect                  IP_10.0.24.7       Spooled                Collections
CS                           IP_10.0.24.8       Spooled                CS
Exec01                  IP_10.0.24.9       Spooled                Exec01
IT                            IP_10.0.24.19     Spooled               IT
Mail04                   IP_10.0.24.6       Spooled                Mail04
Mail05                   IP_10.0.24.12     Spooled               Mail05
Mail06                   IP_10.0.24.12     Spooled               Mail06
Mail9000              IP_10.0.24.20     Spooled               Mail9000
Mail90002            IP_10.0.24.15     Spooled               Mail90002
Mail90003            IP_10.0.24.13     Spooled               Mail90003
Marketing           IP_10.0.24.18     Spooled               Marketing
Payments            IP_10.0.24.16     Spooled               Payments
PDFCreator         PDFCreator:       Spooled                eDoc Printer
Risk                        IP_10.0.24.17     Spooled               Risk
qb.png
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 23

Accepted Solution

by:
Thomas Grassi earned 500 total points
ID: 38867809
Ok my bad do a net view \\i1whlnet02  from your computer post results

Also how is the share mapped?

do a net use on the computer  post results
0
 
LVL 8

Author Comment

by:pzozulka
ID: 38868444
The drive is mapped using regular UNC path.

C:\Windows\System32>net view i1whlnet02

Shared resources at i1whlnet02

Share name                   Type         Used as  Comment

-------------------------------------------------------------------------------
Accounting                     Print           Accounting
BatchRoom01                   Print           Batch Room 01
Checks2                                Print           Checks2
Collect                                   Print           Collections
CS                                            Print           CS
Exec01                                   Print           Exec01
IT                                             Print           IT
Mail04                                   Print           Mail04
Mail05                                   Print           Mail05
Mail06                                   Print           Mail06
Mail9000                              Print           Mail9000
Mail90002                            Print           Mail90002
Mail90003                            Print           Mail90003
Marketing                           Print           Marketing
Payments                            Print           Payments
PDFCreator                        Print           eDoc Printer
QuickBooks Enterprise Data        Disk
Risk                                    Print           Risk
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 38868820
Ok good so the computer can see the shared folder

It is mapped as "Q"

Open Explorer then open the Q Drive see the files?

Then try to add a text file to that folder from the user that is logged on.

Lets see if we have a permissions issue.
0
 
LVL 8

Author Comment

by:pzozulka
ID: 38882405
I was able to add a text file no problem.
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 38882682
Ok so now we know that the user has permissions to acces that folder.

So now back to Quickbooks for the problem.

Can you reestablish the company data?

Some setting in Quickbooks is not correct.

I do not have Quickbooks installed but my GF does will not see her till Thursday I can check it out then if you do not find anything in Quickbooks

Try opening the company data from the file open not by selecting the company file from the sign in screen if I remember right.
0
 
LVL 8

Author Comment

by:pzozulka
ID: 38889717
I lied, it's not mapped using regular UNC path. It was mapped using a DFS mapping. For some reason the DFS mapping does not affect XP users, but this user was a WIN 7 user. I remapped the drive using UNC path, and all is working now.

Thanks for your help.
0
 
LVL 8

Author Closing Comment

by:pzozulka
ID: 38889720
Also how is the share mapped?

It was a drive mapping issue. See solution towards bottom of post.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now