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.
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?