Monday, April 22, 2013

Max Degree of Parallelism Error

An exception of type Microsoft.SharePoint.SPException was thrown.  Additional exception information: This SQL Server instance does not have the required "max degree of parallelism" setting of 1. Database provisioning operations will continue to fail if "max degree of parallelism" is not set 1 or the current account does not have permissions to change the setting.  See documentation for details on manually changing the setting.

When I was installing SharePoint 2013, I ran into the above error while running the PSCONFIG command after installing the SharePoint binaries.

How to fix this

From SQL server management Studio, right click your server in Object Explorer and click Properties. Under the Advanced group modify the property “Max Degree of Parallelism”. Change the value to 1.

I deleted the already created databases in the SQL Server and ran the PSCONFIG command again.

Worked like a charm

1 comment:

  1. Hi, I have a question.
    After the installation, i can reset the value to 0?