Running Quickbooks database server on a modern Windows AD server requires you add an excluded port range to prevent the DNS server from occupying these ports. Note that the QB DB server employs both UDP and TCP transmission in our testing.
Enter the following commands, using the dynamically assigned port number defined in the Quickbooks database server, i.e. 56727 which is used in the below example. 8019 is a static port across all Quickbooks versions. Note that versions prior to 2019 requre a range of ports which is below as well.
Before starting, please stop the DNS and Quickbooks services.
netsh int ipv4 add excludedportrange protocol=udp startport=8019 numberofports=1 store=persistent
netsh int ipv4 add excludedportrange protocol=tcp startport=8019 numberofports=1 store=persistent
netsh int ipv4 add excludedportrange protocol=udp startport=56727 numberofports=1 store=persistent
netsh int ipv4 add excludedportrange protocol=tcp startport=56727 numberofports=1 store=persistent
You can now restart the DNS and Quickbooks services, or restart the computer.
Port ranges for older QB versions:
- QuickBooks Desktop 2018: 8019, 56728, 55378-55382.
- QuickBooks Desktop 2017: 8019, 56727, 55373-55377.
Example for QB 2017:
netsh int ipv4 add excludedportrange protocol=udp startport=8019 numberofports=1 store=persistent
netsh int ipv4 add excludedportrange protocol=udp startport=56727 numberofports=2 store=persistent
netsh int ipv4 add excludedportrange protocol=udp startport=55373 numberofports=10 store=persistent
netsh int ipv4 add excludedportrange protocol=tcp startport=8019 numberofports=1 store=persistent
netsh int ipv4 add excludedportrange protocol=tcp startport=56727 numberofports=2 store=persistent
netsh int ipv4 add excludedportrange protocol=tcp startport=55373 numberofports=10 store=persistent
On upgrades be sure to delete the old port numbers or ranges using the following commands:
netsh int ipv4 delete excludedportrange protocol=tcp startport=<oldport#> numberofports=1
netsh int ipv4 delete excludedportrange protocol=udp startport=<oldport#> numberofports=1