Hello, svcITOSMMT is the service running the SSRS. No delegation. SharePoint Central Administrationv3 Application Pool is running under svcspadm. No delegation. svcSPTeamApPool is running WSSTeamAppPool. No delegation. As my reports are under: http://teams.mednet.ucla.edu/sites/ITOSMMT/Reports/Forms/AllItems.aspx should I run another SETSPN ? SETSPN -a http://teams.mednet.ucla.edu/sites/ITOSMMT/Reports/ ad\svcspadm or SETSPN -a http://teams.mednet.ucla.edu/sites/ITOSMMT/ ad\svcspadm or SETSPN -a http://teams.mednet.ucla.edu/ ad\svcspadm should I add the delegation? Any service to retart after these changes? How to cancel the "setspn" previously" passed if they were wrong? setspn -r hostname (server name ? account name?) how to identify the couple service count/site to remove and not removing all others? C:\Users\dominiqued>setspn -l svcspteamappool Registered ServicePrincipalNames for CN=svcSPTeamApPool,OU=Service Accounts,DC=a d,DC=domain: http/mbspap1 http/mbspap1.ad.domain http/teams.ad.domain http/teams http://teams http://teams.domain C:\Users\dominiqued>setspn -l svcitosmmt Registered ServicePrincipalNames for CN=svcITOSMMT SS. svcITOSMMT,OU=Service Acc ounts,DC=ad,DC=domain: http/teams http/teams.ad.domain http/mbspap1.ad.domain http/mbspap1 http/mbspap1.ad.domain/ITOSMMT http/mbspap1/ITOSMMT MSSQLsvc/MBSQLSPCLA.ad.domain:1433 MSSQLsvc/MBSQLSPCLA:1433 Any impact on the SharePoint Central Administration Console? Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hello, Any information ? Thanks, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

?bump?System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

the account has delegation: Trust this computer for delegation to any services (Kerberos ONLY) but still failing... I cannot display the report An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Login failed for user 'ad\svcITOSMMT'. Thanks, DOmSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hello, How to verify if the setspn passed are picked and ready to use? I am able to run the report on the SharePoint Server where SSRS is installed through Visual Studio but not from IE. On the SSRS Server I have a Kerberos error not sure if it is linked: Log Name: System Source: Microsoft-Windows-Security-Kerberos Date: 6/28/2012 2:59:14 PM Event ID: 3 Task Category: None Level: Error Keywords: Classic User: N/A Computer: SSRS1.ad Description: A Kerberos Error Message was received: on logon session Client Time: Server Time: 21:59:14.0000 6/28/2012 Z Error Code: 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN Extended Error: 0xc0000035 KLIN(0) Client Realm: Client Name: Server Realm: AD Server Name: HTTP/SSRS1.ad Target Name: HTTP/SSRS1.ad@AD Error Text: File: 9 Line: e2d Error Data is in record data. any idea? Thanks,Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

hello, I am reviewing again and again teh steps and nothings pops... Shared Data Source Properties: Datasource.rds Data Source=SSRS1\ITOSMMT;Initial Catalog=ITOSMMT Data Source properties: Data Source=DBSSRSA\ITOSMMT;Initial Catalog=ITOSMMT;Integrated Security=True Is it normal to have two set of properties ??? the Shared Data Source properties is point to the SSRS Server, the Data Source is pointing to the Database Server. What should be the Connection Properties for the Data Source? - "Use Windows Authentication" always after each and every modification... SQL Server Service for the instance restarted SQL Serever Reporting Service for the instance restarted Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hello, still looping with no solution... Any idea? Thanks, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager