|
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: Copy to Clipboard
$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)"
}
}
|