My Oracle Support Banner

Error "No appropriate protocol (protocol disabled or cipher suites are inappropriate)" When Attempting to Connect to a SQL Server P6 Database Using a P6 Database Utility (dbsetup.bat, validate.bat, migrate.bat) (Doc ID 2810056.1)

Last updated on MARCH 20, 2024

Applies to:

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

Symptoms

When using a P6 database utility such as dbsetup.bat, validate.bat, or migrate.bat and attempting to connect to a P6 database hosted in a SQL Server instance, the following error occurs.

SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Socket Layer (SSL) encryption. Error: "No appropriate protocol (protocol disabled or cipher suites are inappropriate)"

 

The issue can be reproduced at will with the following steps:

  1. Launch one of the P6 database utilities from the <P6 install media>\database\ directory.
  2. Enter the database connection credentials and click Next.
  3. Observe the reported error.

Changes

 

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!

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