SharePoint Configuration Wizard Error: This SQL Server instance does not have the required “max degree of parallelism” setting of 1

Error Message: You try to run the SharePoint Configuration Wizard for SharePoint 2013 and you may get this on the first step of the wizard configuration. An exception of type Microsoft.SharePoint.SPException was thrown… 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 to 1 or the current account does not have permissions to change the setting. Cause This happens if the account you’re specified / or logged in as does not have enough...

read more

What Is SharePoint?

Thousands of companies use SharePoint, and more join their ranks each day, yet some still ask the fundamental question: "what is SharePoint?". In fact, more than three quarters of Fortune 500 companies use SharePoint. But, how do so many companies with different operational needs use a single platform? What does it do and how is it so flexible? Why are so many companies using it? SharePoint is a multifaceted tool for business and enterprise users. SharePoint can become different things, depending on the needs of the organization in question. SharePoint is truly a platform from...

read more

PowerPivot Gallery not loading, showing Install Microsoft Silverlight Message

The Issue Power Pivot in SharePoint used to load a gallery the workbooks and shows a screenshot of each report. However, sometimes you open the browser, navigate to the page and find that it’s not loading with a "Install Microsoft Silverlight" message. Even after installing Silverlight, it still says the same thing. Chances are you you are using Google Chrome. That is the crux of the issue. Google decided that Chrome will no long support many different types of plug ins, in an effort to conform with web standards, so they no longer support PowerPivot Gallery in SharePoint...

read more

Accessing Power View Report Builder in SharePoint 2013

SharePoint 2013 allows you to create Power View Reports directly in the browser from Excel Workbooks. To get the Power View Builder: First Make sure you have the Excel files uploaded to the PowerPivot Gallery Library. This can be found on the left menu: Secondly, make sure you use Internet Explorer to do this because it is the only browser that supports Silverlight. Then: While in the PowerPivot Gallery, click the Create Power View Report icon on the right corner of the workbook You will then see the Power View Report builder screen ...

read more