“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
Posts
Hi, I have a question.
ReplyDeleteAfter the installation, i can reset the value to 0?