SharePoint 2016: Failed to create the configuration database. Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown

Failed to create the configuration database SharePoint 2016

In this article, we’ll solve “Failed to create the Configuration Database SharePoint 2016” in SharePoint Configuration Wizard

Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.

Failed to create the configuration database SharePoint 2016

You might also like to read Failed to create the configuration database SharePoint 2019


Failed to create the Configuration Database SharePoint 2016

Unfortunately, I didn’t have an internet connection on the SharePoint Servers to use the SharePoint Preparation Tool to download and install the SharePoint 2016 Prerequisites over the internet automatically.

You might also like to read SharePoint Preparation Tool Download Error

So I went to install the SharePoint 2016 Prerequisites offline that has been installed properly and the SharePoint installation has been started without any complaint.

Once the SharePoint 2016 installation is finished, I tried to run the SharePoint 2016 Configuration wizard to configure the SharePoint 2016 farm.

The SharePoint 2016 Configuration wizard has been started and passed all the pre-steps properly. but when it started to create the SharePoint configuration database (specifically in step 3), it has been failed with the below error.

Failed to create the configuration database.

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.
Failed to create the configuration database in SharePoint 2016 - Failed to create the configuration database An exception of type Microsoft SharePoint Upgrade SPUpgradeException was thrown

I have checked the log and event viewer as shown below. but it was not helpful!!

Failed to create the configuration database.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.
Microsoft.SharePoint.Upgrade.SPUpgradeException: One or more types failed to load. Please refer to the upgrade log for more details.
at Microsoft.SharePoint.Upgrade.SPActionSequence.LoadUpgradeActions()
at Microsoft.SharePoint.Upgrade.SPActionSequence.get_Actions()
at Microsoft.SharePoint.Upgrade.SPActionSequence.get_ActionsInternal()
at Microsoft.SharePoint.Upgrade.SPUtility.GetLatestTargetSchemaVersionBeforeMajorVersion(Type typeActionSequence, Int32 majorVer)
at Microsoft.SharePoint.Upgrade.SPSiteSequence.get_PreviousTargetSchemaVersion()
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.PopulateSequencesTable(StringBuilder sqlstr, Boolean siteSequence)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ConstructSiteNeedsUpgradeQuery(Guid siteId)
at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.GetSiteNeedsUpgrade(SPUpgradeSession session, SPContentDatabase database, Dictionary`2& dictSitesNeedUpgrade, Dictionary`2& dictSitesNeedFeatureUpgrade)
at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.AddNextLevelObjects()
at Microsoft.SharePoint.Upgrade.SPHierarchyManager.Grow(SPTree`1 root, Boolean bRecursing, SPDelegateManager delegateManager)
at Microsoft.SharePoint.Upgrade.SPHierarchyManager.Grow(SPTree`1 root, SPDelegateManager delegateManager)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPServerProductInfo.DetectLocalUpgradeStatus()
at Microsoft.SharePoint.Administration.SPServerProductInfo.DetectLocalProductVersions(SPProductVersions prodVer)
at Microsoft.SharePoint.Administration.SPServerProductInfo.UpdateProductInfoInDatabase(Guid serverGuid)
at Microsoft.SharePoint.Administration.SPFarm.Join(Boolean skipRegisterAsDistributedCacheHost, Nullable`1 serverRole)
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

I also checked the database server to make sure that the issue is not related to the Farm Account permission (DBcreator, SecurityAdmin). but I have noticed that the SharePoint Config database and Admin Content database have been created properly!

You might also like to read Cannot connect to database master at SQL server at SERVERNAME. The database might not exist, or the current user does not have permission to connect


Cause: SharePoint Configuration wizard failed to create the Configuration Database

The WCF Data Services 5.6 tool is not installed properly.

Note: I have tried to uninstall it and install it again, unfortunately, the issue still persists and the SharePoint Configuration wizard has been failed to create the SharePoint Config Database.


Fix: Failed to create the configuration database

You have two option to overcome “Failed to create the configuration database SharePoint 2016” issue:

  1. You must have an internet connection on the SharePoint Server to Install and download the SharePoint 2016 prerequisites online using “prerequisiteInstaller.exe” that will automatically install these prerequisites without any issue.
  2. If no way to use the internet on the SharePoint Servers, so you must let “prerequisiteInstaller.exe” to install WCF Data Services 5.6 tool offline as the following:

Offline Install for WCF Data Services 5.6 tool

Run Command Prompt As Administrator
  • Navigate to the SharePoint media folder.
  • Type the below cmdlet
prequisiteinstaller.exe /wcfdataservices56:"WCF Services Tool Path"

Example: Consider the SharePoint 2016 Media has been mounted to the D:\ volume, and WCF Services Tool is located in “C:\Software\WCFDataServices.exe“, so the command should be

D:\prequisiteinstaller.exe /wcfdataservices56:"C:\Software\WCFDataServices.exe"
SHarePoint 2016: Additional exception information One or more types failed to load
  • You will note that the SharePoint 2016 prerequisites wizard has been started.
  • Click Next to install the WCF Data Services 5.6 tool.
Install WCF Data Services 5.6 tool in SharePoint 2016
  • The WCF Data Services 5.6 tool should be now installed successfully.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown
  • In SQL instance, check if the SharePoint Configuration database and Admin Content database were created! if yes, so you should delete these databases before running the SharePoint Configuration Wizard again.
  • Try now to run the SharePoint 2016 Configuration wizard that should be now completed properly.
Install SharePoint Server 2016 Step by Step

Conclusion

In this article, we have solved Failed to create the configuration database SharePoint 2016. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. by installing the WCF Data Services 5.6 tool offline using SharePoint Preparation Tool.

Applies To
  • SharePoint 2019.
  • SharePoint 2016.
  • SharePoint 2013.
See Also
Have a Question?

If you have any related questions, please don’t hesitate to ask it at deBUG.to Community.

13 thoughts on “SharePoint 2016: Failed to create the configuration database. Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown”

  1. Pingback: SharePoint 2019: SQL Server Recommendations | SPGeeks

Leave a Reply