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

Article translations Article translations
Article ID: 2591753 - View products that this article applies to.
Expand all | Collapse all

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:
Registering a Service Principal Name
For more information about report server trace logs, visit the following MSDN website:
Report Server Service Trace Log
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: October 8, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Reporting Services
Keywords: 
kbexpertiseinter kbfix kbbug kbsurveynew KB2591753

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com