Knowledgebase:
Quickbooks Pro 2017 database service on Domain Controller fails to start, no access to hosted Quickbooks data files
Posted by rbTech Staff, Last modified by rbTech Staff on 10 May 2017 09:33 AM
A weird one, because it had been working for a long time, then stopped after a (Microsoft Update) patch and reboot cycle.

Problem:

Financial users unable to access Quickbooks.  QB data files hosted on the Domain Controller, using the Quickbooks database service

Setup:

Windows 2012r2 Domain Controller, Quickbooks 2017 database manager running on DC

Symptoms:

Database service wont' start, and network diagnostics from the Quickbooks Database server manager GUI fail.  The following event is recorded in the Application log:
The description for Event ID 1 from source SQLANY 16.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

QuickBooksDB27
Could not start server

Diagnostics:

QBCFMonitorService running, but QuickBooksDB27 service is not, and won't start (or immediately stops after start).

Network Diagnostics and repair in the QB database manager GUI fail.

Discussion:

It turns out that the Microsoft DNS service and the QB database service both want to use port 55333. DNS always starts first on a DC, so then the QB service can't bind to the port it wants, and fails out. (Good job, Intuit...).The test case to see if this is the issue is to stop the DNS Server service on the DC, and start the QB database service. If it starts then you've found the issue. DONT FORGET to restart the DNS server service or you'll have very unhappy users! You can permanently fix this by changing the startup parameter in c:\ProgramData\Quicbooks\QBGLOBALAPPCONFIG.ini to a port that is below the DNS server, recommended to be below 49147 (we use 49140).To test, leave the DNS server service running, and restart the QB database

Resolution:

Adjust the service parameters in c:\ProgramData\Quicbooks\QBGLOBALAPPCONFIG.ini from 55333 to 49140, to get the binding out of the range of the Microsoft dynamically assigned high port range of 49152-65535 (The lowest of which are often assigned to the DNS server service because it starts first).

Sources/ Credits:

[1] https://community.intuit.com/questions/1299745-how-do-i-force-quickbooks-database-server-manager-quickbooksdb26-to-use-a-particular-network-configuration
(17 vote(s))
Helpful
Not helpful

Comments (6)
Dee Payton
20 July 2017 06:08 PM
Adjust the service parameters in c:\ProgramData\Quicbooks\QBGLOBALAPPCONFIG.ini from 55333 to 49140, to get the binding out of the range of the Microsoft dynamically assigned high port range of 49152-65535 (The lowest of which are often assigned to the DNS server service because it starts first).

Worked for me.....Thank you!
Jeff Breeze
13 February 2018 09:17 AM
Thank you so much for this write up... I installed the database server on a domain controller that was indeed a DNS server. None of the previous versions of database server had issue (QB 2009 & QB2013), but Quickbooks 2018 definitely did exactly this. I reset the port in the INI file & rebooted (my INI file was in \ProgramData\Intuit\Quickbooks\QBGLOBALAPPCONFIG.ini) and it came back to life. Thank you, thank you, thank you!!!!
Anonymous
14 February 2018 10:35 AM
Thank you so much for your answer, this prevent a long day of stress and blaming AV solutions and Windows Updates!

Marcus
10 April 2018 11:48 AM
Thank you! I have been banging my head against the wall with this problem for awhile. I did the same procedure as Dee Payton above and now Quickbooks works! I did go through and manually add inbound and outbound rules for the port I opened up (49140 in this case).
Anonymous2
04 October 2018 10:00 AM
Thank you for the write up. I verified 55333 was in use by opening a command prompt and typing 'netstat -an' (without the quotes). This allowed me to see that the port was in use without having to stop the DNS Server service.

My server is 2008R2. Note that the path is different that indicated in the article for me. On my server, the path is C:\ProgramData\Intuit\Quicbooks\QBGLOBALAPPCONFIG.ini

I used 'netstat -an' to verify port 49140 was not already in use. It wasn't; therefore, I made the recommended change. This resolved our issue.
Thank you
Krashreport
17 October 2018 11:46 AM
Amazing! Quickbooks and their quest for world domination. Forget about other established best practices, lets just choose a port. Any port.
Thank you so much for this discovery. Would never have found the solution otherwise - would never have thought that any reputable company would deliberately configure their software that way.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).