locked
SharePoint and SSRS RRS feed

  • Question

  • 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

    Friday, April 6, 2012 11:21 PM

All replies

  • Hello,

    Any information ?

    Thanks,

    Dom


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

    Monday, April 9, 2012 10:01 AM
  • ?bump?

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

    Friday, April 20, 2012 8:19 PM
  • 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,

    DOm


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

    Wednesday, June 27, 2012 11:25 PM
  • 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





    • Edited by Felyjos Thursday, June 28, 2012 11:04 PM
    Thursday, June 28, 2012 6:56 PM
  • 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





    • Edited by Felyjos Thursday, June 28, 2012 11:40 PM
    Thursday, June 28, 2012 11:28 PM
  • Hello,

    still looping with no solution...

    Any idea?

    Thanks,

    Dom


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

    Monday, July 2, 2012 1:51 PM