My Oracle Support Banner

How to: Enable Mixed Mode Authentication in Microsoft SQL Server or SQL Express (Doc ID 911875.1)

Last updated on DECEMBER 27, 2021

Applies to:

Primavera Contract Management - Version 12.1 and later
Primavera P6 Enterprise Project Portfolio Management - Version 8.3.2.0 and later
Primavera P6 Professional Project Management - Version 8.3.2.0 and later
All Platforms

Goal

The Microsoft SQL Server installation process includes an option to use Windows Authentication, which authenticates database server logins against the operating system user matrix, or Mixed Mode Authentication, which allows explicit server users to be defined within Microsoft SQL Server in addition to the authenticated Windows users.  The default sysadmin user account is sa.  The Contract Manager database wizard requires this account - or another sysadmin user - to create the Contract Manager databases and authenticated users.  It can not connect via Windows Authentication.

This document describes how to enable Mixed Mode Authentication if it was not chosen during the installation process.

Solution

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
Goal
Solution

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