Excel Services 2010 & 2013 - Kerberos Configuration

Configuring Kerberos for Excel Services is a two step process; Information Gathering and Configuration. Step 1: Information Gathering: 1. Account running “Excel Services Application Web Service Application”: In this example: ECSSvc. Central Administration > Security > Configure service accounts 2.  Account running “Claims to Windows Token Service”:  In this example: Local System. Central Administration >…

11

What is PowerPivot for SharePoint? Part 2.

Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In “What is Power Pivot for SharePoint? Part 1” I discussed the Data Model and how it is a database inside of Excel.  When you publish/upload a regular Excel workbook to SharePoint, that file gets chunked up…

6

Tools and Techniques: Troubleshooting Kerberos in Excel Services and PowerPivot for SharePoint

I have troubleshot many Kerberos cases over the years and here are the best techniques and tools that I have used over the years. 1. Kerberos Event Logging (KB here): Add the following registry value to each machine in the farm that receives Kerberos Traffic: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters Registry Value: LogLevel Value Type: REG_DWORD Value Data: 1…

0