Receiving error during Training Company/Beta Company Install: "...database has existing connections.  Please cancel and resolve the open connections"


During the installation of the Training Company, you can sometimes run into an error "...database has existing connections.  Please cancel and resolve the open connections".  
Here are some suggestions to try and resolve this message:
  • First, try stopping and starting Firebird. This can easily be done from the server via the Windows Start Menu under the DBA Manufacturing>Utilities menu. Alternatively, you can go through Windows Control Panel>Administrator Tools>Services and stop and start the Firebird Server - Default Instance.
  • Second, assuming the above doesn't work, let's do a reboot of the server. We want to do step 1 first, to help jog loose any connections. Immediately upon rebooting try installing the Training Company.
  • Third, if reboot didn't work go to Computer Manager on the server, easiest path is Start menu, then right click on "My Computer" and select Manage. Go into Shared Folders, then Open Files and close anything that deals with DBA or ezijobs. After closing, try to install again.
  • Fourth, if you're on at least build 395 or greater, you can use the single-step Backup and Restore process using DBA's Backup Manager.  After doing the Backup and Restore, the next time you launch the Training Company installation the "existing connection" should be cleared.  Here is documentation on the Backup and Restore process from our online help: Backup and Restore
 If all of the above doesn't initially resolve the issue, make sure that you don't have anything that connects to the database, i.e. an ODBC connection that can restart upon reboot. You might also temporarily turn off virus scanners and third party internet security tool, then install the Training Company/Beta Company, as these can lock files too.