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.
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.
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.
Click on "Update & Security"
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.
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.
Click on "Check for updates" on the left hand side. Once updates have been found, click on "X optional updates are available".
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.
Press "Install updates". Restart the computer once updates are complete.