Summary
How to configure Windows Firewall for Sage 100 Advanced and Premium
Description
Cause
Resolution

- Create Inbound Rule for Sage 100 Service
- Go to Start, Windows Administrative Tools, and Windows Firewall with Advanced Options.
- Right-click Inbound Rules and select New Rule.
- Select Program on the Rule Type screen, and click Next.
- In the Program dialog box, select This program path.
- Click the Browse button and browse to the C:\Sage\Sage 100 Advanced\Mas90\Home\ folder.
- Double-click pvxwin32.exe.
NOTE: pvxwin64.exe for Sage 100 64-bit installations.
- Click Next twice.
- On the Profile screen, select the desired Network Profiles to apply the settings to (Domain, Private, Public), and click Next.
- Enter the Name and Description for the Rule (i.e., Sage 100 (10000)).
- Click Finish.
- Create Inbound Rule for Sage 100 Advanced C\S ODBC Driver Service (if applicable)
- Open Windows Firewall with Advanced Options.
- Right-click Inbound Rules and select New Rule.
- Select Program on the Rule Type screen, and click Next.
- In the Program dialog box, select This program path.
- Click the Browse button and browse to the C:\Sage\Sage 100 Advanced\Mas90\Home\ folder.
- Double-click pvxiosvr.exe.
- Click Next twice.
- On the Profile screen, select the desired Network Profiles to apply the settings to (Domain, Private, Public), and click Next.
- Enter Name and Description for Rule (i.e., Sage 100 C\S ODBC Driver).
- Click Finish.
- Create Inbound rule for SQL Server Instance and SQL Browser Service (Premium only)
NOTE: Apply the following Firewall settings on SQL Server
- Open Windows Firewall with Advanced Options.
- Right-click Inbound Rules and select New Rule.
- Select Program on the Rule Type screen.
- Click Next.
- In the Program dialog box, select This program path.
- Select Browse and go to SQL Server instance you want access to via the firewall, then click Open. (Example: C:\Program Files\Microsoft SQL Server\MSSQL11\Instance_Name\MSSQL\Binn\Sqlserv.exe).
- Click Next twice.
- On the Profile screen, select the desired Network Profiles to apply the settings to (Domain, Private, Public), and click Next.
- Enter the Name and Description for Inbound Rule (i.e., Sage 100 SQL).
- Select Finish.
- Right-click Inbound Rules and select New Rule.
- Select Port on the Rule Type screen, and click Next.
- In the Protocol and Ports dialog box, select UDP.
- Select Specific Port Numbers and then enter the 1434.
- Click Next twice.
- On the Profile screen, select the desired Network Profiles to apply the settings to (Domain, Private, Public), and click Next.
- Enter the Name and Description for the Rule (i.e., SQL Server Browser).
- Click Finish.