Resolving the DATABASE CONNECTION FAILURE error

If you are experiencing database connection issues please try restarting the server computer. If that doesn't work, follow the instructions below.

 

                          The Picture of the Error

                DATABASE_CONNECTION_FAILURE.PNG

 

                          When amber is restarted it will bring you to this screen:

Login_screen.PNG

You may click the green continue button to try connecting again.

 

Some things to check before continuing:

 

Is my Head Office Computer turned on? If it's not then make sure the Head Office Computer is powered on.

Have I reconfigured my router or modem settings without Pacific Amber's consultation? Changing your router or modem information can affect the settings we have in place to connect your network. Any changes to the network infrastructure should be first confirmed by a Pacific Amber representative to avoid a loss in service.

Is there currently an internet service outage in my area? If there is, then you will have to wait until your ISP has finished their work for the internet to resume, and then the connection to your database can function once again.

Is the IP address that the database is trying to connect to correct? Here is a step-by-step guide on how to check: https://amberpos.zendesk.com/entries/109511026-How-to-find-your-database-IP-address-and-SQL-port

Check your internet connection.

Make sure that if you are in the same building your server computer is on the same local network as the computer you're trying to connect with. If you are not in the same building as your server, make sure that you computer has a stable internet connection. See if you can connect to websites such as www.amberpos.com or www.google.com. If you cannot, try restarting your router/modem and trying again.

If these things did not resolve your issue, you may want to try restarting your SQL server service manually. To do so, follow these instructions:

Windows 7 instructions

1. Select the windows start menu by clicking the icon in the bottom left corner of the screen, Then select All Programs in the window that appears.

win7_start_menu.jpe

 

 

2. Overview of All Programs:

win7_all_programs.jpe

     Step 1:  Look through the list until you locate Microsoft SQL Server 2008 or 2012

     Step 2:  Click on the folder, next click on the Configuration Tools folder

     Step 3:  Finally select the SQL Server Configuration Manager.

3. Under the SQL Server Services tab, right click both the SQL Server and SQL Server Agent and choose the start/restart option. When the SQL Server icon is green, that means it is running, and when it is red, that means it has stopped.

win7_config_manager.png

 

 

Windows 8/10 instructions

1. Use your mouse cursor and right click the windows button  Windows_button.PNG  in the bottom left of your screen and select computer management OR Go to any file explorer window and right click on This PC on the left hand side, then click manage.

windows_start_button.png                 OR                     This_PC.png

 

2. Navigate to SQL server services

Select_SQL_server_services.PNG

        Step one: Expand services and applications

        Step two: Expand SQL server configuration manager

        Step three: Select SQL server services

 

3. Right click the SQL Server process and click start if not running, or restart if the service is already running.

Click_start.png

 

If this does not resolve your connection issues please call our support line at (866) 919-0123 and indicate a system down emergency.

 

 

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk