Recently, I was installing Sitecore 9 (Update 2) on my local system. Actually, I already installed Sitecore 9 (initial version) on the same system earlier. But, while installing Sitecore 9 (Update 2) I get error saying that Contained database authentication is off and cannot deploy the databases. Due to this the installation process ends with error.
I tried to look in SQL Server and found that I already enabled contained database authentication. However, I was not able to go through for this new installation.
After looking for other articles, I get through the following Sitecore Community thread which solved my issue.
Sitecore 9 Installation Fails with “Error: .NET SqlClient Data Provider Msg 12809”
For quick solution I putting the solution below from the thread here in this blog so anyone having such issue can quickly get rid of it.
Use master GO sp_configure 'show advanced options', 1 GO RECONFIGURE WITH OVERRIDE GO sp_configure 'contained database authentication', 1 GO RECONFIGURE WITH OVERRIDE GO sp_configure 'show advanced options', 0 GO RECONFIGURE WITH OVERRIDE GO Happy installation!!!!