Attaching SharePoint 2010 content database (Windows/SQL 2008 R2) database to SharePoint 2013 (Windows/SQL 2012)

If you are migrating from SharePoint 2010 to SharePoint 2013 and trying to attach a SharePoint 2010 content database that used to reside in SQL 2008 R2 to SQL 2012 you should know the following.

During the upgrade process of attached database you might get an error message similar to this:

"WARNING The [SharePoint - 25000] web application is configured with claims authentication mode however the content database you are trying to attach is intended to be used against a windows classic authentication mode."

The reason you are getting error message above is because all new Web Applications in SharePoint 2013 are by default created in Claims Authentication Mode.

To get around this, create the new Web Application in SharePoint 2013 using PowerShell command with Windows Classic Authentication Mode:

New-SPWebApplication -Name "Contoso Internet Site" -ApplicationPool "ContosoAppPool" -AuthenticationMethod "Kerberos" -ApplicationPoolAccount (Get-SPManagedAccount "CONTOSO\jdoe") -Port 80 -URL "https://www.contoso.com"

Microsoft: http://technet.microsoft.com/en-us/library/gg276326.aspx

Please be aware that this authentication mode is no longer supported. At this point you can run the upgrade once more and move on.

If you use anything written here, you do it on your own risk!

My very first post! Oy, so excited!!!

Here goes my very first post.

I will blog mostly about SharePoint 2010 and SharePoint 2013. I am no expert, these blogs are just about my daily interactions with SharePoint.

Wish me luck!