How to add the Pervasive Database Manager and open necessary TCP ports in your Windows firewall to ensure Pervasive & Sage Pastel can communicate.
Adding the rules can assist in preventing errors & speed up your copy of Sage Pastel.
- Click Search and type in Firewall
- Select the option Windows Defender Firewall
- On the left, select the option Advanced settings
- On the left, select the option Inbound Rules
- On the right, select the option New Rule…
- Select the option Program and click Next>
- Select ‘This program path:’ and put in the path %ProgramFiles% (x86)\Pervasive Software\PSQL\bin\w3dbsmgr.exe then click Next>
- Select Allow the connection and click Next>
- Select Domain, Private and Public and click Next>
- Enter a Name: Pervasive Database Manager
- Optionally enter a Description i.e. Access to Pervasive Program/Database, click Finish to save the rule
- On the left, select the option Inbound Rules
- On the right, select the option New Rule…
- Select the option Port, click Next>
- Select Specific local ports, Enter 1583, 3351, click Next>
- Ensure Allow the connection is selected , click Next>
- Select Domain, Private and Public and click Next>
- Enter a Name: Pervasive Ports
- Optionally enter a Description i.e. Access to Pervasive Ports, click Finish to save the rule
- Repeat the above 2 steps for Outbound Rules
ESET Firewall Rules for Pervasive
- Open the main program window of your ESET Windows product
- Press the F5 key on your keyboard to access Advanced setup
- Click Network Protection>Firewall, expand Advanced and click Edit next to Rules
- Click Add
- Type a name for the rule into the Name field e.g. Pervasive Access
- Under Direction select Both
- Under Action select Allow
- Under Protocol select TCP & UDP
- Click the Local tab, in the Port field put in 1583, 3351
- Then under Application copy and paste %ProgramFiles% (x86)\Pervasive Software\PSQL\bin\w3dbsmgr.exe – Do NOT enter the name of the application
- Click the Remote tab, enable port numbers 1583, 3351
- Click OK>OK>OK