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 moreSharePoint Versions, Cumulative Updates, Service Packs and Build History
Hello SharePoint Admins! From hearing the pains of keeping up with and identifying which updates are the latest, we’ve decided to make life easier for all. This is a list that we have built with the complete list of SharePoint Cumulative Updates, hotfixes, Services Packs. We plan on keeping this up to date. If we missed something please leave a comment below and we will update. Also if you have an issues with an update it would be nice to share with community as well in the comments. SharePoint 2016 Release Date Build KB Name Contained Updates August 2017 KB...
read moreSharePoint 2013 Search Architecture and Topology
Among a variety of other improvements, one of the most notable changes in SharePoint 2013 was the introduction of an improved search function. The new search functionality varied from prior versions in that it combined SharePoint search and FAST search into a single platform. Prior versions of SharePoint used a variety of different search tools like WSS search, foundation, etc. This created some fundamental inefficiencies and overly complicated architecture. SharePoint 2013 streamlined this structure, while adding a slate of new components and other topology changes; the examples include...
read moreHistory of SharePoint: The Past, Present and Future
SharePoint has come a long way over the years, from its early days, as a simple server management tool, to its use today, as a sophisticated file sharing and management software suite. Over the years, SharePoint has been used by companies to maximize productivity, build incredible websites, and much more. It has grown with the Internet and changed over time, becoming more powerful and comprehensive with every iteration. Better yet, the future of SharePoint looks bright, with incredible new innovations on their way for the next generation of users. About SharePoint Created by Microsoft in...
read moreUnable to Open File "Compressed Stream" in Excel Power Pivot and Analysis Services (SSAS)
Overview of the error message This error happens in Excel when you try to refresh some data from SQL Server Analysis Services (SSAS) and the refresh returns the error "Unable to Open file compressed stream". Often this workbook is a using PowerPivot. Solution This solution fixes the issue most of the time. In SQL Analysis Services: Open Microsoft SQL Server Management Studio Connect to the instance of Analysis Services (SSAS) Right click on the server node Click Properties Click General Find and modify "Network \ Responses \ Enable Compression" to FALSE...
read moreSharePoint AIIM Survey Infographic March 2015
SharePoint surveys come across periodically and I love them. They are an excellent source into the the technology that can help us make better decisions. This is one of the latest ones that should appeal to executives and stakeholders deciding to develop solutions on SharePoint. I can very well understand those numbers and are not a big shock to me, and it is nice to see now some real numbers put together by a Survey from AIIM (Association for Information and Image Management) underwritten by ASG, AvePoint, Colligo, Concept Searching, Collabware, EMC, Gimmal Group, K2 and OpenText that can...
read more