.NET SqlClient Data Provider error when installing WDP
.NET SqlClient Data Provider error when installing WDP
|
|
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:
-
Follow the Sitecore documentation to install the Sitecore Azure Toolkit.
-
Download the non-WDP, non-SXA Coveo for Sitecore package associated with your version of Sitecore from the links below.
-
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 "*" -verboseFor example:
ConvertTo-SCModuleWebDeployPackage -Path "C:\Packages\Coveo for Sitecore 10.2 5.0.1460.0.zip" -force -DisableDacPacOptions "*" -verbose -
Install the generated WDP package in your Sitecore instance. The WDP package should be located in the same folder as the original
.zipfile, have the same name, and end with.scwdp.zip. -
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.