4

I am getting the following error when I attempt to install Sitecore 9.1 (initial release) with SIF (v2.0.0). (Note this IS after some failed installs, but I believe I have removed everything to do with those attempts).

Error Code: ERROR_EXECUTING_METHOD More Information: Could not deploy package. Warning SQL72023: The database containment option has been changed to None. This may result in deployment failure if the state of the database is not compliant with this containment level. Error SQL72014: .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.

I found this post suggesting to remove everything from previously failed attempts (which I believe I have...there are no Sitecore 9 DBs or users hanging around).... and I even tried a new install with a brand new prefix, and a new SQL user/password..... but am still getting the same thing.

The contained database authentication setting is correctly set to 1 before the installation, and the DBs it DOES get to install are correctly set to Partially contained databases. Does anyone have any other suggestions for what I can do to get this fixed?

Thanks.

  • Can you see in the logs at which database it fails? I had the same yesterday, but removing the databases solved the issue as you wrote. – Tamás Tárnok Dec 16 '18 at 9:37
  • Can you share the install.ps1 file here? and what SIF commands is actually failing here? – Ahmed Okour Dec 16 '18 at 17:28
  • I'm not running an install.ps1 script. I actually think this was from some custom script that may have produced the issue. (and it seems like there WAS duplicate databases in there. More to come.... – Sean Holmesby Dec 17 '18 at 11:05
  • Which SQL Server version are you using ? Make sure you are using SQL Server SP1 and not SQL Server 2016. (According to the Sitecore compatibility table, Sitecore 9.1 initial release needs at least SQL Server 2016 SP1) – Mohamed Krimi Dec 2 at 18:15
6

It sounds like you still have a database or maybe a user left over.

How did you remove the failed installs? If you are running from the example script in the download comment out and in the Install-SitecoreConfiguration and Uninstall-SitecoreConfiguration lines and use that to run the uninstall. That should remove everything for you.

  • It looks like a custom script that had a bug where it was re-installing xConnect-xp0 a second time throughout the script.... meaning that even though I initially had no databases.... after the first xConnect install they'd exist...and it was the second run that was failing. My bad. It definitely IS a case of the database already existing.... – Sean Holmesby Dec 17 '18 at 11:10
  • Ran into this issue with the Habitat install-xp0.ps1 script for XP 9.1.0 – Joost Apr 19 at 11:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.