?
Solved

Quickbooks issues with FQDN

Posted on 2011-10-03
11
Medium Priority
?
852 Views
Last Modified: 2012-06-21
Dear Experts,

FQDN don't work with quickbooks, Quickbooks server been joined to the domain "domain.local", quickbooks server name set to quickbooks "Quickbooks database managment server".

from nslookup, I get replay for both quickbooks and quickbooks.domain.local. but from client when I connect to quickbooks server I can not change to "single user name".

I have added host recode under client C:\Windows\System32\Drivers\Etc\hosts" file, if i set it to below setting, user can change to single user mode:
quickbooks        10.x.x.x

BUT if i set it to FQDN can't, it will give error and advise to change to "host  multi user mode", this is where that client hold the file.
quickbooks.domain.local       10.x.x.x

is that correct?

thanks
0
Comment
Question by:uknet80
  • 6
  • 5
11 Comments
 
LVL 2

Accepted Solution

by:
LlanoV earned 2000 total points
ID: 36908850
Hello uknet80,

We have deployed a number of Quickbooks installation using FQDN's

We made sure that once the PC's were enrolled into the domain that the AD profiles issued mapped drives to the relevant Quickbooks repositary.

We then installed Quickbooks on the server using the server / sharing option. The PC's were setup using the client option.

All PC's then open the relevant company file making use of the mapped drive eg. x:\

Is your deployment similar? If not try the approach as indicated above...

Regards
Llano
0
 

Author Comment

by:uknet80
ID: 36909248
my steps was as follow:

1- joined server to the domain.
2- moved server to right OU
3- installed "Quickbooks database management server"
4- made sure record been added to DNS server.
5- move quickbooks files to share folder and give access to everyone.

am i missing anything?
0
 
LVL 2

Assisted Solution

by:LlanoV
LlanoV earned 2000 total points
ID: 36909407
That sounds good so far. You now need to add the following script file info to your AD profiles. The script files are stored in your netlogon folder of the server. In this example the Quickbooks files aresaved in the folder mapped as p:

 Place where you will tell AD to execute the attached script file script.txt
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Assisted Solution

by:LlanoV
LlanoV earned 2000 total points
ID: 36909435
Once you have done the steps above your users should she a p: drive now mapped when they click on "Computer" within windows

All that need to be done now is to open the P: drive, once you have insled the client on the PC's, and double click on the company folder to access it via the network
0
 

Author Comment

by:uknet80
ID: 36909639
I have created share drive manually from client machine (Tool->Map Network Drive)
does it make difference?
0
 
LVL 2

Assisted Solution

by:LlanoV
LlanoV earned 2000 total points
ID: 36909656
The only real differnce is that should the drive become diconnected then the AD policies will regenerate them

What version of Quickbooks has been installed?
0
 

Author Comment

by:uknet80
ID: 36915369
sorry for late replay

it is Quickbooks Enterprise Solution Version 11
0
 
LVL 2

Assisted Solution

by:LlanoV
LlanoV earned 2000 total points
ID: 36915958
Cannot wait to get hold of it this end. South Africa is a bit behind and only have 2010 available.

Has your problem been resolved?
0
 

Author Comment

by:uknet80
ID: 36916280
not yet,

I have reinstalled "Quickbooks database management server", while server was part of domain,  I coudn't start QuickbooksDB21 service, I was getter error "the service did not start due to a logon failure" error 1069, then under services  double clicked on QuickbooksDB21 service and from LogOn tab changed username from  QBDataServiceUser21 to domain administrator name, and started the service, now I can't change to milti mode, nighter through using only computer name from host file or domain name.
0
 

Author Comment

by:uknet80
ID: 36922627
guy i have spoken with quickbooks support they said, quickbooks dosn't support FQDN, it only supports host name, that is were you have to added under host file.

is that true?
0
 

Author Closing Comment

by:uknet80
ID: 37013187
the solution is to add hostname to host file for each workstation,
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

862 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