We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

How to Connect Popdock to your Local Database on your Computer

How to Connect Popdock to your Local Database on your Computer

If you have a local Dynamics GP or SQL database that you configured on your computer and you want to add it to Popdock, there is some configuration that needs to be completed before Popdock will be able to connect to it. Depending on your network setup you will need to open up your outward-facing IP address and port number of the database so that Popdock can connect. Everyone’s network configuration and IP address are different so these first steps of opening your port number will vary on your internet modem or router provided by your internet service provider or your company’s network.

You will first need to know what port number your database instance is set to. By default, it is normally 1433, but please confirm by following the steps on this KB Article:  How to find the TCP Port number your SQL Instance is listening on.

Configuring a Router for Port Forwarding

1. To configure a router for port forwarding you will need to know how to log into it.  Some of the most common routers use a default IP Address of 192.168.0.1 or 192.168.1.1.  One way that you can confirm this is by opening a command prompt and using the “ipconfig /all” command.  The default gateway shown in the returned data is normally your router’s IP.

2. Use this IP Address and enter it in your browser. This will normally take you to a login for your router.

3. The information for the login can also sometimes be on a sticker on your router.

4. Once you are logged into your router, you will want to look for your Port Forwarding settings. Here is an example of where a Linksys router has it under Security > Apps and Gaming > Single Port Forwarding.

Here you would add the application name, which you can name Popdock if you like.  The External and Internal Port would be the port number of your SQL database. The default port number is 1433.  Protocol is TCP and UDP, so this will be set to Both. 

If it requires the device’s IP address, this will be the IP Address that your router is assigning to your device.  This can also be found by doing the “ipconfig /all” from a command prompt.  Once you have it all completed, save the settings.  Then you now need to configure your windows firewall.

Configuring Windows Firewall

1. Open your windows menu and type “firewall”.  You should see the Windows Defender Firewall as an option. Open Windows Defender Firewall.

2. Go to Advanced settings.

3. Go to Inbound Rules to create a new rule.

4. In the New Inbound Rule Wizard window, select Port for the Rule Type.  Then select Next.

5. On the Protocol and Ports step, choose TCP and for the port options, choose Specific local ports. Enter the port you are using for your database or enter 1433 for the default port number.  This is the port that should match what you have configured in your router port forwarding.  Once you have these configured, select Next.

6. For the action step, select Allow the connection and then select Next.

7. Leave the default selection for the Profile step and then select Next.

8. Enter Name for the inbound rule and then select Finish.

Configuring your Popdock Connector

You should now be ready to connect your local database to Popdock using your computer internet facing IP Address (not the 192.168.1.27 assigned by your router), along with the port that you have opened up on your network for Popdock to connect through.  The easiest way to get your internet IP Address is to do an internet search for “What is my IP4 address”.

Your internet IP Address is issued by your Internet Service Provider or ISP.  Sometimes it is static, but most of the time it is dynamic and could change when your ISP does an update or forces it to change.

After you have entered all the information required, select Validate. If there are no errors, you will see Connect under Actions. 

Questions on connecting to your local database? Email support at support@eonesolutions.com.

Content
Configuring a Router for Port Forwarding Configuring Windows Firewall Configuring your Popdock Connector

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters