Skip to content
April 8, 2018 / kiranpatils

Fix for Database error during Sitecore 9 Installation

Challenge:

While installing Sitecore 9 for few of the exciting things I’m working on [Soon to be shared!] faced some issues. Which is obvious with any new things. I’m sure you as well. Not tried yet?! Then this quote is for you:

In a day when you don’t come across any problems, you can be sure that you are travelling in a wrong path.

https://quotefancy.com/quote/32294/Swami-Vivekananda-In-a-day-when-you-don-t-come-across-any-problems-you-can-be-sure-that

So, thought to write it down. With the goal that it helps someone, somewhere on this earth! [Might be on moon someday! :)]

I had to do couple of attemps to do Sitecore 9 Installation with same prefix. But at one point of time. It was stuck with this error:

Warning: 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.

You are also facing the same? Then this post has fix for you!

Solution:

Here are the steps I did:

  1. Connected to SQL Server Management Studio and deleted databases which were with the prefix, which was trying to install.
  2. Configured Contained Database Authentication as per Installation guide’s chapter Prerequisites and Requirements [Why? Note from SC documentation “To enable SQL server to allow for the creation of users when using the Sitecore Install Framework, ensure that the target SQL Server is configured in a way that allows users and logins to be contained at the database level. To do this, set the contained database authentication server configuration option to 1 (on): “]
sp_configure 'contained database authentication', 1;
GO
RECONFIGURE;
GO

Now, try again. And if all good. You should see your brand new Sitecore 9 instance up and running!

Good reads:

  1. https://chebalt.wordpress.com/2017/11/22/sitecore-9-installation-tips/
  2. http://blog.baslijten.com/gotchas-while-installing-sitecore-9-using-the-sitecore-installation-framework/
  3. https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases

Hope this helps!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: