Max Degree of Parallelism Error

“An exception of type Microsoft.SharePoint.SPException was thrown.  Additional exception information: This SQL Server instance does not have the required "max degree of parallelism" setting of 1. Database provisioning operations will continue to fail if "max degree of parallelism" is not set 1 or the current account does not have permissions to change the setting.  See documentation for details on manually changing the setting.”

When I was installing SharePoint 2013, I ran into the above error while running the PSCONFIG command after installing the SharePoint binaries.

How to fix this

From SQL server management Studio, right click your server in Object Explorer and click Properties. Under the Advanced group modify the property “Max Degree of Parallelism”. Change the value to 1.

I deleted the already created databases in the SQL Server and ran the PSCONFIG command again.

Worked like a charm

Datasheet view Error for SharePoint with Office 64-bit versions

When you upgrade your Office versions to newer versions (mostly 64-bit), you would have come across the below error trying to access datasheet view in SharePoint:

The list cannot be displayed in Datasheet view for one or more of the following reasons:

- A datasheet component compatible with Microsoft SharePoint Foundation is not installed.

- Your Web browser does not support ActiveX controls.

- A component is not properly configured for 32-bit or 64-bit support.

Solution:

Follow the below kb article from Microsoft:

http://support.microsoft.com/kb/2266203

• Install the 2007 Office System Driver: Data Connectivity Components                   http://www.microsoft.com/en-us/download/details.aspx?id=23734