Categories:
  🠪  General

Email
  🠪  Servers
  🠪  Testing
  🠪  Tips

Hardware
  🠪  3D Printing
  🠪  Apple
  🠪  Batteries
  🠪  Drives
  🠪  Edgerouter
  🠪  Electronics
  🠪  Laptop
  🠪  Modems
  🠪  Phone
  🠪  Printers
  🠪  Raspberry Pi
  🠪  Tablets
  🠪  Testing
  🠪  Virtualization

hidden
  🠪  General

Links
  🠪  Interesting
  🠪  Media

Network
  🠪  Data
  🠪  Testing
  🠪  VPN

Scripts
  🠪  Batch
  🠪  Linux
  🠪  Powershell

Servers
  🠪  Databases
  🠪  Misc
  🠪  Website

Software
  🠪  Other

Utilities
  🠪  Backup
  🠪  Fix Issues
  🠪  Recovery

Video
  🠪  Editing

Websites
  🠪  HTML
  🠪  Testing

Windows
  🠪  Adjustments
  🠪  Issues
  🠪  Remote Desktop
  🠪  Security
  🠪  Slow
  🠪  Software
  🠪  Startup

Submit Entry
Airin's Notes

Category: Software 🠪 Other
Quickbooks Database Server Manager fails to start causing users to be stuck in Single User Mode
December 1, 2023

Quickbooks 2021 Error switching to multiuser mode - H202 or H505
https://quickbooks.intuit.com/learn-support/en-us/open-programs/how-to-fix-error-h202-and-h505/00/186029

If the database manager is running on a server running DNS server, then the DNS service may be using the same port UDP 55333.
Temporary Solution: Stop DNS server, Start QuickbooksDB31 Service, then start DNS.

http://www.devonstephens.com/quickbooks-database-manager-conflicting-dns-server/


-- An example error log from Event Manager on the server:
The description for Event ID 1 from source SQLANY 17.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:

QuickBooksDB31
Unable to initialize requested communication links


-- Also:
Could not start server




Powershell script to fix this. I have several customers where I have this set to run periodically using Task Scheduler:

$Services = Get-Service

$AllRunning = $true
Foreach ( $Service in $Services ){
if ( $Service.Name -like "QuickbooksDB*") {
Write-Output "$($Service.Name) = $($service.Status)"
if ( $service.Status -ne "Running" ){ $AllRunning = $false }
}
}

Write-Output "Stopping DNS Service..."
if ( $AllRunning -ne $true ){
Foreach ( $Service in $Services ){
if ( $Service.Name -eq "DNS") {
$Service.Stop()
Start-Sleep -seconds 5
}
}
}


Write-Output "Starting Quickbooks Services..."
Foreach ( $Service in $Services ){
if ( $Service.Name -like "QuickbooksDB*") {

if ( $service.Status -ne "Running" ){
Write-Output "Starting $($Service.Name)..."
$Service.Start()
Start-Sleep -seconds 6
}
}
}


Write-Output "Starting DNS Service..."
if ( $AllRunning -ne $true ){
Foreach ( $Service in $Services ){
if ( $Service.Name -eq "DNS") {
$Service.Start()
Start-Sleep -seconds 6
}
}


$Services = Get-Service
}



# Show final status of services...

Write-Output ""
Write-Output ""
Foreach ( $Service in $Services ){
if ( $Service.Name -like "QuickbooksDB*" -or $Service.Name -eq "DNS" ) {
Write-Output "$($Service.Name) = $($service.Status)"

}
}








Keywords: Multi User, Intuit





This site is meant to be used as a reference for myself, although others may find it useful. I use it to keep track of certain fixes, software, and other solutions which I may need while assisting customers. The page layout is pure HTML/CSS and is kept simple to optimize loading time and fast results.

Return to Airin's Computers