You are currently offline, waiting for your internet to reconnect

FIX: An update is available to add SPN information for service accounts to the Reporting Services log file

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 3
After 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\LogFiles
The 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:For more information about report server trace logs, visit the following MSDN website:For 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
Properties

Article ID: 2591753 - Last Review: 10/08/2011 04:17:00 - Revision: 2.0

Microsoft SQL Server 2008 Reporting Services

  • kbexpertiseinter kbfix kbbug kbsurveynew KB2591753
Feedback
html>=">f?DI=4050&did=1&t=">