Summary
This article describes an update that is available to add service account service principal name (SPN) information to the Reporting Services log file.
Note After you apply this update, diagnostic information is created that can help troubleshoot Kerberos authentication issues.
More Information
This update is available in Microsoft SQL Server 2008 Service Pack 3. For more information about the service pack, click the following article number to view the article in the Microsoft Knowledge Base:
2546951 List of the bugs that are fixed in SQL Server 2008 Service Pack 3After you apply this update, you can find the SPN output in the Reporting Services log file. For a default instance of SQL that is installed to drive C, the default location for the log file is as follows:
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFilesThe diagnostic information that this update creates resembles the following:
<Date> <Time>:: i INFO: The UserAccountControl value for the service account is ###
<Date> <Time>:: i INFO: Registered valid SPNs list for endpoint 2:
<Date> <Time>:: i INFO: SPN Whitelist Added <IPv6> - <fe80:0:0:0:5d93:ecb2:92f2:d55e>.
<Date> <Time>:: i INFO: SPN Whitelist Added <IPv4> - <IP Address>.
<Date> <Time>:: i INFO: SPN Whitelist Added <IPv6> -<IP Address>.
<Date> <Time>:: i INFO: SPN Whitelist Added <ComputerNamePhysicalDnsFullyQualified>
<Date> <Time>:: i INFO: SPN Whitelist Added <ComputerNamePhysicalNetBIOS>
<Date> <Time>:: i INFO: SPN Whitelist Added <ComputerNamePhysicalDnsHostname>
<Date> <Time>:: i INFO: SPN Whitelist Added <ComputerNameDnsFullyQualified>
<Date> <Time>:: i INFO: SPN Whitelist Added <ComputerNameNetBIOS>
<Date> <Time>:: i INFO: SPN Whitelist Added <ComputerNameDnsHostname>
<Date> <Time>:: i INFO: SPN Whitelist Added <Reserved> - <localhost>.
References
For more information about service principal name, visit the following Microsoft Developer Network (MSDN) website:
Registering a Service Principal NameFor more information about report server trace logs, visit the following MSDN website:
Report Server Service Trace LogFor more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
