Description

Sitecore XP requires Contained Database Authentication to be enabled. This setting is mandatory for Sitecore Installation Framework (SIF) to create all users for each database during the installation, as well as for Azure PaaS deployments, because this is a requirement of Azure SQL.
If you need the Contained Database Authentication disabled, consider the following solution.

Solution

To use all databases without Contained Database Authentication enabled, consider the following approach:

• To install just the instance without databases, after the Sitecore Installation Framework has been installed, you must inform Web Deploy to ignore SQL and DACPAC tasks inside the WDP. This can be done by adding the "Skip" directive. In this case, Web deploy will not execute the DACPAC or SQL scripts inside a certain WDP. To skip database deployment, proceed as follows:
  1. Add the following "Skip" directive to all SIF JSON files that are used during the installation as follows:

     "Skip": [
                       { "ObjectName": "dbDacFx" },
                       { "ObjectName": "dbFullSql" }
             ],        

     Note that this needs to be added to the SIF task containing the "WebDeploy" Type. For more details see the following figure:
     
     
     If you disable SQL related operations, you must deploy databases and create users manually. DACPAC files can be found in the corresponding web deploy packages.
  2. Сontinue with the Sitecore XP installation as usual.