During my Tech Ed Australia session (#auteched #DAT417) DAT417 | Solving the problems of SharePoint and SSRS Integration, I demonstrated a number of tools which can be used to troubleshoot reporting services, particularly Kerberos issues. This is the list of those tools.
Powershell and PowerGUI (http://powergui.org)
Powershell is your friend. If you are using SharePoint 2010, you should start getting used to using PowerShell. I am still getting to grips with it myself, but it is incredibly powerful. For example, I installed and configured the whole SharePoint environment for this demo using Powershell. There is a project on CodePlex called AutoSPInstaller which you can configure to do the installation for you.
Allows you to view underlying properties of Active Directory objects such as SPN.
SetSPN –X and SetSPN -S
New parameters in Windows 2008. The X parameter checks for duplicate SPNs and the –S parameter adds an SPN, but checks for duplicates and aborts if it finds one.
View a list of tickets
“This tool is used to display ticket information for a given computer running the Kerberos protocol.”
“Fiddler is a Web Debugging Proxy which logs all HTTP(S) traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP(S) traffic, set breakpoints, and “fiddle” with incoming or outgoing data.”
“Tool to allow capturing and protocol analysis of network traffic.”
Network Analysis tool
ULS Viewer (http://code.msdn.microsoft.com/ULSViewer)
ULSViewer allows users to open a ULS log file and display its contents in a user friendly format. Users can then perform advanced functions such as filtering, sorting, highlighting, loading logs, appending logs, etc in order to single out the data that is important to the user. This information can be used to diagnose problems with machines running ULS services, or to monitor machines and the events they create in realtime.