.NET SqlClient Data Provider error when installing WDP

In this article
Introduced in

This issue was introduced in the October 22, 2025 release of Coveo for Sitecore version 5.0.1460.0.

Symptoms

When you install a Coveo for Sitecore WDP package, you see an error similar to the following:

Error: .Net SqlClient Data Provider: Msg 12809, Level 16, State 1, Line 5 You must remove all users with password before setting the containment property to NONE.

Cause

The WDP packages for the Coveo for Sitecore October 22, 2025 release (5.0.1460.0) were built using an incorrect argument value.

Resolution

To work around the issue, generate WDP packages for this Coveo for Sitecore release using the correct argument value as follows:

  1. Follow the Sitecore documentation to install the Sitecore Azure Toolkit.

  2. Download the non-WDP, non-SXA Coveo for Sitecore package associated with your version of Sitecore from the links below.

  3. Convert the package you downloaded to a WDP using the PowerShell command below. Replace <PATH> and <SC_VERSION> to reflect the path and the filename of the package you downloaded.

    ConvertTo-SCModuleWebDeployPackage -Path "C:\<PATH>\Coveo for Sitecore <SC_VERSION> 5.0.1460.0.zip" -force -DisableDacPacOptions "*" -verbose

    For example: ConvertTo-SCModuleWebDeployPackage -Path "C:\Packages\Coveo for Sitecore 10.2 5.0.1460.0.zip" -force -DisableDacPacOptions "*" -verbose

  4. Install the generated WDP package in your Sitecore instance. The WDP package should be located in the same folder as the original .zip file, have the same name, and end with .scwdp.zip.

  5. If applicable, repeat the process for Coveo for Sitecore SXA by downloading the relevant package from the links below, generating the WDP, and installing it in your Sitecore instance.