How to configure Windows Firewall for Sage 100 Advanced and Premium (with video)
Description
Cause
Resolution
[BCB:328:GENERAL WARNING:ECB]
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).
