Thursday, September 5, 2013

SP2013 Config DBs: ERROR "This SQLServer instance does not have the required max degree of parallelism"

During installation of SharePoint 2013, you may come across the above error. A SQL 2008 configuration setting required for this was only a recommendation in the previous versions of SharePoint installations but now is a prerequisite for SharePoint 2013 installation. To configure it, here is how:

Using your SQL Management Studio:

- Connect to your SQL database instance
- Right-click the instance name
- Click on Properties, to open the server properties window.
- Select Advanced, to view advanced settings
- Expand the Parallelism section, if not expanded
- Change the property "Max Degree of Parallelism" to 1 and click Ok to exit.

No comments: