cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Multiple requests for database updates

I just downloaded and ran updates from QB Pro 2016 to QB Pro 2019, on my client's computers.

They have 9 companies and I carefully made sure I opened, and QB updated each one to the new 2019 format. At no time did I receive any error messages. Everything seemed to happen as it was supposed to.  In fact, I kept a paper checklist of the companies as I ran the updates on the "server", so I know I didn't miss any. 

Then I went to the workstations, and updated the QB desktop clients. When I tried to open several of the company files to confirm connectivity and proper function, I got a dialog box telling me I had to update the database before I could open it with the "new" version.  I had to do that on four of the nine companies.  It does seem to have stopped requesting the updates, but I would like to know why it happened in case it starts happening again, or happens at another client's office.   Any ideas?    Thanks !

 

3 Comments
QuickBooks Team

Re: Multiple requests for database updates

Hi there, @tomecole.

 

You'll need to install the QuickBooks Database Server Manager on other computers to avoid being prompted to update. I'd be happy to provide some details about this.

 

In QuickBooks, you're prompted to update the database because it's not updating automatically. It's necessary to install the Database Server manager when there are new releases. This way, all workstations are up to date with the latest releases and will download automatically.

 

To install the QuickBooks Database Server Manager, you can follow the steps below:

  1. Double-click the installer for your QuickBooks and start the Installation Wizard.
  2. Select Next if the computer is connected to the Internet and able to download an update.
  3. Close other open programs, then select Next.
  4. Read the terms of the Software License Agreement. If you agree, select I accept the terms in the license agreement, then select Next.
  5. Select Custom or Network Options.
  6. Choose an installation type.
  7. Select Yes, allow access.
  8. Enter the License Number and Product Number.
  9. Follow the on-screen instructions to complete the installation.

You may also read this article for more information: Install, Update, and Set Up the QuickBooks Database Server Manager.

 

Please feel free to click on the Reply button if you have any other concerns.

Experienced Member

Re: Multiple requests for database updates

Thank you for your reply .

 

Either I did not explain the situation clearly enough, or something has changed very dramatically with this 2019 release.

 

Computer #1 functions as their "server". It runs both the client software and the database manager.

 

Computers #2 and #3 just have the QB client installed.  This is the way I have performed dozens upon dozens of installations  over the years.  Why install the database manager on a workstation (#2 or #3) that is not going to be managing the single database located on computer #1?  It would get confusing and lead to complications.

 

I did the 2019 update first on the "server", and while still logged in there opened each of the 9 companies  to update the database format of each.  I then opened each (on the "server") in multi-user mode.  Then I updated the 2 clients.

 

When I finish updating each client I always open the company files to confirm function and connectivity (we all know how easily those can become an issue).  Computer #2 opened each company normally.

 

When I tried to open four of the nine of the company files (located and managed on #1) from the #3 computer, it asked me to update those databases, that had already been updated.   

 

I have never seen this anomalous behavior before and was wondering if anyone had a suggestion as to why it happened and what to do if my customer calls saying their computer is asking to "re-update" the databases.

QuickBooks Team

Re: Multiple requests for database updates

Thank you for providing me with a detailed explanation, @tomecole.

 

It's possible that the computers used to open the company files don't meet the system requirements for QuickBooks Pro 2019. Let me provide you the requirements and help you from there.

 

There are different systems requirements to ensure their compatibility with QuickBooks 2019.

 

Here's are the operating systems compatible for QuickBooks 2019:

  • Windows 10, all editions including 64-bit
  • Windows 8.1 (Update 1), all editions including 64-bit
  • Windows 7 SP1, all editions including 64-bit
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows Server 2011, Standard and Essentials
  • Windows Server 2008 R2 SP1

As for the Database Server requirements, here are some of them:

  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows Server 2011
  • Windows Server 2008 R2 SP1
  • Windows 10, Windows 8.1 (update 1)
  • Windows 7 SP1 (Enterprise and Professional editions only)

Also, you may need to completely update the patch for your QuickBooks. You'll need to select the version you're using before successfully updating the patch.

 

9.PNG

 

If you're still getting the same prompts, I suggest contacting our QuickBooks Desktop Support. This way, they can view your account. Also, they can perform a screen share, wherein they can view the prompts and help you remove them.

 

Here's how you can contact them:

  1. Log in to your QuickBooks account.
  2. Press F1 on your keyboard.
  3. Click on Contact Us.

Please let me know if you have any other questions. I'll be here to help.