• mortalic (12/8/2016)


    I do think that's the issue (spns) however the sql server for sure has spn's, and the ssrs server too.

    It's the service account that sharepoint/ssrs is using that I think is the issue.

    On the sharepoint server it shows itself as the ssrs server as well, however when I look, I see the SSRS Configuration Manager and it will open, however it doesn't actually let you do anything. Is this normal for SSRS integrated with sharepoint? I'm no stranger to SSRS, but I've never used it in integrated mode before.

    You use Report Manager if you are in native mode or with integrated mode go to Sharepoint Central Administration and go to Applications. Report Services is listed there.

    You need to check if the accounts are trusted for delegation.

    This article will help you walk through all the steps for spns, delegation, which one from which service, etc.

    How to configure SQL Reporting Services in SharePoint Server for Kerberos authentication

    https://support.microsoft.com/en-us/kb/2723587

    Sue