Skip to main content

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.
Labels:

Comments

Post a Comment

Popular posts from this blog

Zambia's first K2 BlackPoint roll-out

Reporting to you live from Code|Influence... My colleague and I have been managing our organization's SharePoint infrastructure for some time now and we have just rolled out the first K2 BlackPoint in the country, intended mostly for SharePoint workflow developments.
8 comments
Read more

How to document your SharePoint Projects.

Here are the essential documents you need to complete… Initiation Business Case: To justify the financial investment in your SharePoint Project, you need to write a Business Case. It lists the costs and benefits, so everyone knows what the return on investment will be. Feasibility Study: Before you kick-off your SharePoint Project, you need to determine whether your project is feasible, using a Feasibility Study. SharePoint Project Charter: You then need to document the objectives, scope, team, timeframes and deliverables in a SharePoint Project Charter. Planning SharePoint Project Plan: You need to create a Project Plan listing all of the tasks required to undertake your SharePoint Project from start to finish. Every task must be scheduled, so you know what needs to be done and when. Resource Plan: Next, you need to plan your resources by documenting the money, equipment and materials needed for your SharePoint Project. Quality Plan: You then need to set quality targets, so that the S...
4 comments
Read more