My Oracle Support Banner

P6 Database Tools: 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)" (Doc ID 2810056.1)

Last updated on SEPTEMBER 27, 2021

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 attempting to connect to a SQL Server database using any P6 Database Tool (dbsetup.bat, validate.bat, migrate.bat)
the following error occurs.

ERROR
-----------------------
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)"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch the tool.
2. Enter and submit the connection credentials to the SQL Server database.

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
References


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