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
When amber is restarted it will bring you to this screen:
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: 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.
2. Overview of All Programs:
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.
Windows 8/10 instructions
1. Use your mouse cursor and right click the windows button 
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.
OR 
2. Navigate to SQL server services
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.
If this does not resolve your connection issues please call our support line at (866) 919-0123 and indicate a system down emergency.
0 Comments