The user is not a farm administrator. Please address the validation failures and try again – PowerPivot Configuration Tool

I was installing PowerPivot for SharePoint on a new app server in a multi server farm and came across the following error, “The user is not a farm administrator. Please address the validation failures and try again.”, problem is the PowerPivot install account was the Farm Admin, the SharePoint install was done with the Farm Admin account, the Farm Admin had all access required. So after scouring the internet and trying everything that I could find

  • Install PowerPivot addin on all servers in the farm
  • Remove Farm Admin from admin group, re add Farm Admin to admin group
  • reinstall all components using SharePoint install account

I remembered that when I ran the SharePoint Configuration wizard to add the new app server to the existing Farm, I referenced the Farm to join with an IP rather than a Computer name, this led to the ultimate solution:

  • Uninstall everything (SharePoint and PowerPivot for SharePoint)
  • Install SharePoint
  • Run configuration wizard, be sure to reference the Farm by Name not IP
  • Install PowerPivot for SharePoint
  • Run the PowerPivot for SharePoint 2013 Config tool

Issue resolved, loud Arg, Sigh of relief


MDX with SSAS 2012 Cookbook

I have recently had the opportunity review the Book, MDX with SSAS 2012 Cookbook, the Latest in a series of MDX Cookbooks written by Tomislav Piasevoli and Sherry Li

Small Book Cover

 Buy it Here

I am a fan of the cookbook approach when it comes to learning MDX. Analysis Cubes are built to answer common business questions, the recipes in this cookbook deliver methods and techniques to help business Intelligence professionals answers these questions and deliver the goods.  MDX with SSAS 2012 Cookbook does not assume that the reader has a working knowledge of MDX providing basic recipes in the first chapter to build a foundational knowledge of the language. Each subsequent chapter of the book builds upon this foundation adding new tools and techniques to the readers MDX arsenal;

including common requirements like

  • Time intelligence
  • Percentage Calculations
  • Moving Averages
  • Ranking
  • TopN/BottomN Reporting
  • Conditional Formatting of Data

For what it is worth, I would recommend this book to anyone that works with multi dimensional databases regardless of their experience with MDX, I know I am happy to have a copy!