|
Pervasive PSQL communicates through three ports. Your firewall(s) and routers need to allow access to the following ports for remote access with the server database engine:
Typically, you do not need to modify the ports unless you have a conflict with them.
Note
The Windows operating system uses port 139 for authentication to the operating system. An alternative to allowing access to port 139 through a firewall is to enable security on the Pervasive PSQL database. Once security is enabled, users, such as "Master," are authenticated to the database through the database's own security features. See To turn on security using Pervasive PSQL Explorer and To create a new user using Pervasive PSQL Explorer , both in Advanced Operations Guide.
Port assignments 1583 is configurable for the server through the Pervasive PSQL utilities. See TCP/IP Port in Advanced Operations Guide. This port is manually configurable for clients as explained in this section.
Port assignment 3351 is manually configurable for the server and the clients as explained in this section.
Ensure that the port configurations match on both the server and all clients. You must stop then start the database engine for the port assignments to take effect.
The services file is a text file used by the operating system for network communications. In the services files, you can manually assign the ports used by Pervasive PSQL Server and its clients. The following table summarizes this.
Note
After changing port assignments in the services file, you must stop then start the Pervasive PSQL database engine for the changes to take effect. See Starting and Stopping the Database Engine in Pervasive PSQL User's Guide.
|
Chapter contents
Prev topic: Using SPX to Connect to a Windows 32-bit Server
|