SP2013: This SQL Server Instance does not have the required maxdegree of parellism setting of 1

Hi, At a client today installing SP2013 and getting this error now for the second time.

Quick and simple to fix, just need to remember to do it before i run the farm wizard...

Dont have a SQL 2012 now to get some screenshots.

You can run this script in SQL

sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'max degree of parallelism', 8;

GO

RECONFIGURE WITH OVERRIDE;

GO

Or via the SQL Gui:

Open SQL Management Studio

Right Click on the server and go to properties.

Click on advanced and if i remember corectly you have to go down about halfway where you must set this value to 1.

You dont need to restart SQL server after ding this so no down time.