Error received while testing a connection to a Peoplesoft database via the setup.jsp page:
"Verify Connection Error - Network error IOException: Connection Refused"
1. Select Maintenance | General | Peoplesoft Connect.
2. Verify that the hostname, service name and db listener port are set correctly:
For PeopleSoft on SQL Server:
- Launch MS Enterprise Manager
- Right click the db server and select Properties.
- In the General tab | click on the Network Configuration button, then highlight TCP/IP and select Properties to find out the port that your Peoplesoft db is using. The default port is 1433.
- Verify that the user can register the database from Enterprise Manager
- Validate if SP4 for SQL Server has been updated recently. MDAC updates could cause this error.
For Peoplesoft on Oracle:
- Bring up DOS Prompt
- Type in tnsping db_alias_name
- Once the data is returned, select Maintenance | General | Peoplesoft Connect and compare the hostname, service name and db listener port agaist the DOS Prompt.
