My Oracle Support Banner

DBSetup.bat Error: SQLServerException: The TCP/IP connection to the host <HOSTNAME>, port <PORT#> has failed. Error: "connect timed out. Verify the connection properties." (Doc ID 2724839.1)

Last updated on NOVEMBER 06, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 and later
Primavera P6 Professional Project Management - Version 18.8 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a database via DBSetup.bat, the following error occurs on the "Connection Information" screen:


ERROR

SQLServerException: The TCP/IP connection to the host <HOSTNAME>, port <PORT#> has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."

STEPS

The issue can be reproduced at will with the following steps:
1. Attempt to create a database via DBSetup.bat.
2. Observe the reported error on the "Connection Information" screen.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.