How to find your database IP address and SQL port

First, make sure that you are on the server computer. You can check by searching for "SQL server management studio" in windows. If it show's up then you're on the server.

1.PNG

 

How to find internal IP address (local network connection).

1. Hold the windows key on your keyboard and then press the "R" key to open up the "Run" box.

2.PNG

 

2. Type "cmd" into the text box and then click "OK".

3.PNG

 

3. In the black box that comes up type "ipconfig".

4.PNG

 

4. Look for the title "Ethernet adapter" and look for "IPV4 address", this is your local IP address. (The title may be "Wireless adapter" if you are on a wireless internet connection).

5.PNG

 

How to find external IP address (Internet connection).

1. Open up your internet browser of choice (Example: Internet explorer, Mozilla Firefox, Google Chrome) and go to www.canyouseeme.org.

6.PNG

 

2. This will display your external IP address. It will also allow you to check whether your port is open. Your SQL port must be open to be able to connect over the internet (Usually port 1444).

 7.PNG

 

How to check which port SQL is using and whether it is open.

1. Go into windows file explorer and right-click "This PC" then click "Manage".

8.PNG

 

2. Navigate to "Protocols for MSSQLSERVER" by expanding "Services and Applications", "SQL server Configuration Manager", "SQL Server Network Configuration" and select "Protocols for MSSQLSERVER".

9.PNG

 

3. Right-click "TCP/IP" and select "Properties".

10.PNG

 

4. Go to the "IP Addresses" tab and scroll to the bottom until you see "TCP port". This is what port SQL is using.

11.PNG

 

5. In your internet browser go to www.canyouseeme.org. Put the port that you saw in the last step into the port field and click "Check Port".

 12.PNG

If your port is closed it will look like this:                                                                         If your port is open it will look like this:

14.PNG15.PNG

If your port is closed you will need to contact AmberPOS support to open it up for you.

 

Where to put the IP address into AmberPOS

When launching AmberPOS after a database connection failure it will launch into this screen:

 13.PNG

Just populate the "Server IP, Port" field with the server IP address and the port separated by a comma.

Note: Only use the external IP address when connecting to a remote server that is at another location.

 

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk