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