SQL Does Not Have the Required MaxDegree of Parallelism Setting of 1

SharePoint Adam

So you were quick to jump on SharePoint 2013 Preview, eh? If you are a good SharePoint person and are attempting to run SharePoint Products Configuration Wizard with least privilege, then you are probably at this post because you hit this:

Configuration Failed

Failed to create the configuration database.

This SQL Service instance does not have the required “maxdegree of parallelism” setting of 1. Database provisioning operations will continue to fail if “maxdgree of parallelism” is not set 1 or the current account does not have permissions to change the setting…

Reason

The default setting for this in SQL is 0 and this was not a requirement, but a recommendation, in SharePoint 2010. Our new buddy SharePoint 2013 requires that MAXDOP be set to exactly 1. Furthermore, as foreshadowed above, if you ran the wizard with a highly privilege account on SQL, then the account would automatically make the settings…

View original post 145 more words

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s