Community
Showing results for 
Search instead for 
Do you mean 
Reply

How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Copper Super Contributor
Posts: 55
Country: United States

How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

[ Edited ]

How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db? 

 

My router must open port 80 for internet sync to work.  I would like to enable Windows Firewall or some other software firewall. However, I cannot figure out how to turn on the firewall and still pass the sync.  Currently, the firewall must be off.

 

Suggestions in the ACT kb do not work.

 

For example: "Troubleshooting Internet Synchronization in ACT!"

 

Thanks in advance.  - mike

 

 

Content edit.  Fixed link.

Message Edited by dlunceford on 12-15-2008 09:12 AM
Silver Elite Contributor
Posts: 3,353
Country: United_Kingdom

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Mike

 

These are the firewall exceptions that I use.

 

Firewall Exceptions 
  1. C:\Program Files\Act\Act For Windows\ actsage.exe
  2. C:\Program Files\Act\Act For Windows\ act11.exe
  3. C:\Program Files\Act\Act For Windows\actemail.exe
  4. C:\Program Files\ACT\Act for Windows\act.outlook.services.exe
  5. C:\ProgFile\MS SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
  6. C:\ProgFile\MS SQL Server\90\Shared\sqlbrowser.exe
  7. C:\Documents and Settings\<username>\Application Data\ACT\ACT For Windows 11\Preferences\UKPreferences206.xml
  8.  C:\Documents and Settings\<username>\Application Data\ACT\ACT For Windows 9PreferenceBak.xml
  9. ADD Port*. Name SQL TCP, Port 65100, TCP option. (Network Synchronisation).
  10. ADD Port*. Name SQL TCP, Port 65100, UDP option. (Network Synchronisation).
  11. ADD Port*. Name SQL TCP, Port 1433, TCP option. (SQL)
  12. ADD Port*. Name SQL UDP, Port 1433, UDP option. (SQL)
 *Opening ports is a potential security risk.

 

This KB article gives a more detailed description of the process: http://tinyurl.com/62ysy9

 

Jeff

 

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Moderator
Posts: 4,395
Country: USA

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

SQL UDP port is 1434
Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Are you sure you're talking about Internet Sync? This is only in the Premium version

 

You should probably look at Application sync. See this ACT! Knowledge Base article - How To Set Up Application Synchronization in ACT!

 

Then see - How To Setup Hamachi® VPN For Remote Synchronization With ACT! by Sage and ACT! by Sage Premium 2005...

 

 

Copper Super Contributor
Posts: 55
Country: United States

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Jeff_Granger and David Lunceford's suggestions did not work. After including all these exceptions to Windows Firewall, the situation is the same - I can sync from the Remote when the Publisher is set with Windows Firewall OFF, but not ON.

 

The Remote is a laptop that is connecting wireless through the same router as the Publisher, which is wired.  Could the fact that they are on the same network be a problem?

 

And yes, I have ACT! 11 Premium on all machines.

 

Thanks, - mike

Silver Elite Contributor
Posts: 3,353
Country: United_Kingdom

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Mike

 

I'm still not clear what method of synchronisation you are trying to use.

 

Essentially you have three options:

1. Network Sync - this is the "usual" option with ACT Premium where you use the ACT! Network Sync Service on the Publisher machine to handle incoming sync requests.

2. Application Sync - Network sync service in not running (or not available in the Standard version of ACT), but you check "Accept Incoming Syncs" under Tools > Synchronise in ACT!

3. Internet Sync - Used typically when the subscriber computer is at a remote location and there's no VPN link.

 

As you describe running the sync over a wifi connection I suspect you have set up either Network Sync or Application Sync, but could you confirm which as it would help trying to resolve your problem.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Copper Super Contributor
Posts: 55
Country: United States

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

I have ACT! 11 Premium on all machines. This is an new, upgrade from Act 6.  I am using internet sync on two computers only - a desktop Publisher, and a laptop Remote - in order to debug the installation .  They are currently at the same location for convenience while completing this test installation, and currently the laptop is connected wirelessly to the same network as the Publisher.  But normally the laptop will be on the road. A VPN network does not exist.

 

My goal is that all remote computers will sync ACT! sync via the internet. Since all local computers except the Publisher are laptops that are only local temporarily, during the time they are local they will continue to sync via the internet.

 

Does this clarify the situation?

- mike

Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Copper Super Contributor
Posts: 55
Country: United States

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

I gave up on Internet Sync. I never got it to work.  Instead I discovered that Network Sync will work over the internet.  It was simple to set up and works well. 

 

It's  a shame that ACT doesn't make it clear that Network Sync will work perfectly well over the internet, rather than just locally as the title "Network (inside of a firewall)"implies.

 

 - mike

Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: How to setup Windows Firewall to allow ACT! 11 Internet Sync from remote db?

Mike, the instructions to do this are listed in this ACT! Knowledge Base article -

How To Use the ACT! Network Sync Service Across the Internet

 

Network sync can require additional thought to keep it secure when on the internet, unless also using a VPN