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 >…
Tag: Constrained Delegation
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…
PowerPivot 2013 for SharePoint – "External Data Refresh Failed" using Interactive Data Refresh via "Use the authenticated user's account"
When refreshing in the browser you may come across this error: "External Data Refresh FailedAn error occurred while working on the Data Model in the workbook. Please try again.We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh:<Connection>" This happens when you choose Data > "Refresh…