Database Connection Failure - Caused by Windows Update

A previous Windows update released on July 10, 2018, introduced an issue that prevents SQL Server from starting automatically after a system reboot. SQL Server is a database engine that is required to be running in order for AmberPOS to start.

If you try starting up AmberPOS in the morning and you are getting a Database Connection Failure error, please first verify that your IP address and SQL port are populated as in the example below.

DatabaseConnectionFailure.PNG

Your server IP might be 192.168.1.5,1444 or 192.168.0.1,1444 or even 10.1.10.5,1455, this you will need to verify. If this value is blank then please contact our support line at 1-866-919-0123 for assistance finding your server's IP address.

POSDatabaseInformation.PNG

As long as the IP address is populated you can try pressing the Continue button and see if AmberPOS loads up. If it doesn't and you get the Database Connection Failure error then you will need to install the updates. Otherwise you can also check out this article on "Resolving the DATABASE CONNECTION FAILURE error" article on how to start SQL Server Manually.

 

This problem can be fixed by installing the following updates:

Windows 10 - July 16, 2018—KB4345421 (OS Build 17134.167) https://support.microsoft.com/en-ca/help/4345421/windows-10-update-kb4345421

Windows 7 - July 18, 2018—KB4338821 (Preview of Monthly Rollup) https://support.microsoft.com/en-ca/help/4338821/july242018kb4338821osbuildpreviewofmonthlyrollup

 

These updates only need to be installed on your server computer.

 

How to install Windows Updates

Windows 10 Updates:

Press the Windows key on your keyboard or click on the Windows button in the bottom left corner of your screen to open up the start menu. From here click on the settings cog.

Windows10Settings2.png

 

Click on "Update & Security"

Windows10UpdateAndSecurity.PNG

Check for and install available Windows updates. The update needed to fix this issue is:

2018-07 Cumulative Update for Windows 10 Version 1803 for x64-based Systems (KB4345421)

Restart the computer once the update is finished installing.

Windows10CheckForUpdates.PNG

 

Windows 7/8/8.1 Updates:

Press the Windows key on your keyboard or click on the Windows button in the bottom left corner of your screen to open up the start menu. From here search for "Windows Update" and select the top result.

StartMenuSearch.PNG

Click on "Check for updates" on the left hand side. Once updates have been found, click on "X optional updates are available".

WindowsUpdate.PNG

We recommend checking all important and optional Windows updates for fixes and security patches. The update required to fix this issue is: 2018-07 Preview of Monthly Quality Rollup for Windows 7 for x64 based Systems (KB433821). Check the box next to this update and press OK.

OptionalUpdates.PNG

Press "Install updates". Restart the computer once updates are complete.

WindowsUpdate.PNG

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk