pzozulka
asked on
QuickBooks 13: The company file is located on another computer and QuickBooks cannot contact that computer
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?
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?
ASKER
Yep, followed all those steps short of running QuickBooks file doctor.
Do you have it working now?
ASKER
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.
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?
on computer open command prompt type net share //servername
Post results
does the share that the database files show on the computer?
ASKER
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
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\
Printer Drivers
E$ E:\ Default share
prnproc$ C:\WINDOWS\system32\spool\
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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.
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.
ASKER
I was able to add a text file no problem.
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.
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.
ASKER
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.
Thanks for your help.
ASKER
Also how is the share mapped?
It was a drive mapping issue. See solution towards bottom of post.
http://support.quickbooks.intuit.com/support/Articles/SLN40493