For performance reasons, we recommend disabling the Windows firewall if you want to access Act! from your own network.
Due to the delay in accessing the Act! database from outside, it is not recommended to access the SQL server over WAN.
Therefore we recommend the following solutions.
- Act! for Web
- Act! Sync
- Terminal Server
- VmWare View
- Panologic TSE
If you want to reach the database from outside (most likely via a DMZ), then you need to open some ports.
By default, these are the ports you need to configure if you have a firewall between your database server and your client (or Act! for Web Server).
|1433 (Standard SQL Server Port)
|1434 (Standard SQL Server Port)
|80 (Default Web Port if you are using ACT! Internet Synchronization, or ACT! by Sage Premium for Web)
o ensure that it is the correct network port.
To ensure that it is the correct application port.
Use the following steps to verify the current port number that the Publisher database monitors for application synchronization.
Instructions to find out the dynamically distributed ACTDIAG SQL port.
Tutorial: SMB over TCP vs. SMB over NBT
Enabling and disabling NBT to control ports 137, 138, and 139
Disable NBT (NetBIOS over TCP/IP) to close UDP ports 137 and 138 and TCP port 139. Enable NBT to reopen these ports.
The communication process of ports 139 and 445 is realized using the SMB (Server Message Block) protocol. That is, you use the name list information in the DNS server to find the object you need to communicate with. If you successfully get the IP address of the object, you can access the shared resources. Windows versions prior to Windows 2000 use the NetBIOS protocol to solve the computer name problem. The IP address is determined by sending the NetBIOS name of the communication partner to the WINS server. CIFS, inherited from Windows 2000 and later versions, uses DNS to solve the computer name problem.
On systems after Windows 2000, port 445 is used. The file sharing function itself is the same as port 139, but this port uses a different protocol than SMB. It is the latest CIFS (Common Internet File System) protocol used in Windows 2000. CIFS and SMB have different methods for resolving computer names. SMB uses NetBIOS and WINS to resolve computer names, while CIFS uses DNS. When ports 139 and 445 are open at the same time, port 445 is preferred for file sharing on the network. When port 445 is closed, file sharing on the network uses port 139, but since Windows 10, file sharing uses only port 445. When port 445 is closed, file sharing services cannot be used. Therefore, in the internal corporate network environment where the file and print server uses Windows, ports 139 and 445 cannot be closed.