Tag Archives: sharepoint 2016 prerequisite installation

failed to create configuration database

Posted on by
Reply
There is an error “failed to create configuration database” while installing sharepoint 2016 with an addition message “sql server instance does not have the required “max degree of parallelism” setting of 1″.

failed to create configuration database

What is Max Degree of Parallelism ?
When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution. SQL Server considers parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population.

Read this for more details

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

How to fix it ?

  1. Open Microsoft SQL Server Management Studio
  2. Login with sysadmin user
  3. Right Click on instance name and select properties >> Advanced
  4. Change Max Degree of Parallelism to 1
  5. Restart the SQL Service

 

Failed to create configuration database exception SharePoint 2016

Posted on by
Reply

Error :

There was an error while running Install Prerequisite (prerequisiteinstaller.exe)  “Failed to create 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.”

psconfigsharepoint2016

Solution:

you may face this issue while installing manually instead of using the prerequisiteinstaller.exe

Uninstall WcfDataServices and then reinstalling the WcfDataServices using the prequisiteinstaller.exe automatically or using command with the appropriate parameter.

prerequisiteinstaller.exe /wcfdataservices56: WcfDataServices.exe location

Then delete two databases from SQL Server which are created by previous psconfiguration and run Products Configuration Wizard again, it will be successful.

Unable to install Microsoft Information Protection and control Client 2.1 error SharePoint 2016

Posted on by
3

When I run the Install Prerequisite (prerequisiteinstaller.exe) there was an error during installation. Unable to install Microsoft Information Protection and control Client 2.1  error appears as below.

Unable to install Microsoft Information Protection and control Client Error SharePoint 2016

This means that there is error in downloading automatically and this needs to be downloaded and installed manually.

You can click on the links to download directly.

Application Server Role, Web Server (IIS) Role
Microsoft SQL Server 2012 SP1 Native Client
Microsoft ODBC Driver 11 for SQL Server
Microsoft Sync Framework Runtime v1.0 SP1 (x64)
Windows Server AppFabric 1.1
Windows Identity Foundation (KB974405)
Microsoft Information Protection and Control Client 2.1
Microsoft WCF Data Services 5.6
Microsoft .NET Framework 4.6
Cumulative Update Package 7 for Microsoft AppFabric 1.1 for Windows Server (KB 3092423)
Visual C++ Redistributable Package for Visual Studio 2012
Visual C++ Redistributable Package for Visual Studio 2015

Install all above prerequisites manually  which shown installation error and run the install Prerequisite again, it shows Install Completely.