SharePoint 2013 Configuration Wizard Error ‘maxdegree of parellelism’

SharePoint 2013 Configuration Wizard Error ‘maxdegree of parellelism’

When trying to configure SharePoint 2013 on SQL Server 2012 I got the following error – ‘This SQL Server Instance does not have the required maxdegree of parellism setting of 1’

It turns out this is a simple fix, just run the following SQL script to set the ‘maxdegree of parellism’ setting to the required value of 1 -

[code lang="sql"]
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'max degree of parallelism', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
[/code]

You will need to login with an account that has the appropriate SQL permissions to do this, the SharePoint installation account won’t suffice. After you have changed the setting, delete the config database and re-run the wizard.

Hope this helps!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">