none
Problems with Report Services 2008 Integration in Sharepoint Foundation 2010 RRS feed

  • Question

  • hi Folks,

    i ihave tried to solve my problem with this entry, but it has not fixed the issue.

    I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic:

    Central Administration jpg
    When I try to access direct the RS Url the I get an access denied error please help.

     

    thx a lot

    Wednesday, September 8, 2010 10:03 AM

Answers

  • Hi DADDELTANTE,

    From your first post, you encountered the error "Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages" when you configured Reporting Services SharePoint Integrated mode via SharePoint Administration Center.

    The error means the SQL Server Reporting Services(SSRS) Report Server is not configured to run with SharePoint Integrated mode or the Report Server is unreachable.

    So, please firstly make sure the Report Server catalog databases is configured to use SharePoint Integrated mode.

    Suppose we have configured the database in SharePoint Integrated mode, now we need to troubleshoot the connection issue.
    From your last post, you encountered the error 402.1. If I am correct, you are meaning 401.2(as far as I know, the 402 status code is not currently in use), right? If so, yes, as you mentioned, it should be a security issue. The parent code 401 means Access denied, and the 401.2 means logon failed.  It is failed due to server configuration.
    Additionly, from your description, you are going to use Windows Authentication for the Integrated mode, so I assume the SSRS is configured to use Kerberos authentication. Going back to the conneciton issue, it may be due to the SSRS is configured to use Kerberos authentication, however, the Service Principal Name(SPN) is not registered correctly for the service account the SSRS is running under.

    In order to fix the issue, please follow these steps:

    1. Open the Reporting Service Configuration Management.
    2. Go to 'Service Account' tab, remember the account name.
    3. Logon the Domain Control with domain administrator.
    4. Register the SPN for the account we got from step2. We need to register the following two SPNs.
          SETSPN -A HTTP/VMT-MOSS:86 <service account>
          SETSPN -A HTTP/VMT-MOSS.domain.com:86 <service account>
    5. Now, make sure we are able to access the Report Server from all clients(e.g. the SharePoint server, the clients) with http://VMT-MOSS:86/ReportServer

    If we are able to connect to the Report Server, please re-configure the SharePoint Integrated mode via SharePoint Administration Center.

    Final, below is a checklist that include the general items we need to check when configure SharePoint Integrated mode:

    1. Use the correct version of the Reporting Services Add-in for SharePoint Integrated mode.
    2. The Reporting Services Add-in for SharePoint Integrated mode is installed in all SharePoint Web Front End(WFE)s.
    3. The WFE is installed in the Report Server machine.
    4. The Report Server catalog database is configured in SharePoint Integrated mode.
    5. If using Kerberos authentication, make sure the SPNs for the Report Server and the SharePoint sites are registered correctly.

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, September 9, 2010 6:46 AM
    Moderator

All replies

  • Can you please let us know which Operating system are you using? You need to open IE with Run As "Administrator" option. For me I got the issue fixed with this. Even you may try out the same if it is relevant.

    Regards,

     


    Phani Note: Please mark the post as answered if it answers your question.
    Wednesday, September 8, 2010 10:31 AM
  • hi,

    i have tried with runas admin, no success. the system config is : WIN 2008 R2, SQL 2008 R2 (development ed), Sharepoint Foundation 2010 and Visual Studio 2010.

     

    thx

    Wednesday, September 8, 2010 11:25 AM
  • Are you able to browse to the Report Server from the SharePoint server?  If so, this should only be a configuration issue.  Try changing the SharePoint authentication to use Trusted not Windows Auth.If you are not using Kerberos in your environment you need to use Trusted in SharePoint, not Windows Authentication.  You should only use Windows Authentication if you have Kerboros enabled throughout your environment.

    Regards,

    Steve

    Wednesday, September 8, 2010 12:36 PM
  • no I am not able to browse RS on the local system ==> Access denied 402.1. I don't want to switch the auth mode to trust, because my vs2010 development environment is working properly. when i switch to , i guess some security issues will be raising then on the build process !?

    The only solution at the moment is, to install a second SQL instance on the same machine with a dedicated RS-service....

    Wednesday, September 8, 2010 12:50 PM
  • Hi DADDELTANTE,

    From your first post, you encountered the error "Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages" when you configured Reporting Services SharePoint Integrated mode via SharePoint Administration Center.

    The error means the SQL Server Reporting Services(SSRS) Report Server is not configured to run with SharePoint Integrated mode or the Report Server is unreachable.

    So, please firstly make sure the Report Server catalog databases is configured to use SharePoint Integrated mode.

    Suppose we have configured the database in SharePoint Integrated mode, now we need to troubleshoot the connection issue.
    From your last post, you encountered the error 402.1. If I am correct, you are meaning 401.2(as far as I know, the 402 status code is not currently in use), right? If so, yes, as you mentioned, it should be a security issue. The parent code 401 means Access denied, and the 401.2 means logon failed.  It is failed due to server configuration.
    Additionly, from your description, you are going to use Windows Authentication for the Integrated mode, so I assume the SSRS is configured to use Kerberos authentication. Going back to the conneciton issue, it may be due to the SSRS is configured to use Kerberos authentication, however, the Service Principal Name(SPN) is not registered correctly for the service account the SSRS is running under.

    In order to fix the issue, please follow these steps:

    1. Open the Reporting Service Configuration Management.
    2. Go to 'Service Account' tab, remember the account name.
    3. Logon the Domain Control with domain administrator.
    4. Register the SPN for the account we got from step2. We need to register the following two SPNs.
          SETSPN -A HTTP/VMT-MOSS:86 <service account>
          SETSPN -A HTTP/VMT-MOSS.domain.com:86 <service account>
    5. Now, make sure we are able to access the Report Server from all clients(e.g. the SharePoint server, the clients) with http://VMT-MOSS:86/ReportServer

    If we are able to connect to the Report Server, please re-configure the SharePoint Integrated mode via SharePoint Administration Center.

    Final, below is a checklist that include the general items we need to check when configure SharePoint Integrated mode:

    1. Use the correct version of the Reporting Services Add-in for SharePoint Integrated mode.
    2. The Reporting Services Add-in for SharePoint Integrated mode is installed in all SharePoint Web Front End(WFE)s.
    3. The WFE is installed in the Report Server machine.
    4. The Report Server catalog database is configured in SharePoint Integrated mode.
    5. If using Kerberos authentication, make sure the SPNs for the Report Server and the SharePoint sites are registered correctly.

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, September 9, 2010 6:46 AM
    Moderator
  • hi Jin,

    thx for your help, i have made some successful steps to the solution, but now i am getting another security failure 'wtf':

    0x80090005 RS is unable to decrypt security key. restore key or delete the whole data !?

     

    thx^^

    Thursday, September 9, 2010 8:15 AM
  • Hi,

    The error 0x80090005 may be due to the Reporting Services service account is changed.

    To fix the issue, please restore the backup encryption key. Or, if there is no data in the Report Server data(means Datasources, Reports), please delete the encryption key directly.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, September 9, 2010 9:56 AM
    Moderator
  • ok, deleted encryption key access denied comes again. do know you where virtual directory is located. can it be configured in IIS ? all changes made with a domain admin account...
    Thursday, September 9, 2010 11:37 AM
  • Good Morning,

     

    I am receiving the same error as outlined initially in this thread. I'm using SQL Server 2008 R2 and SharePoint 2010. Report Server database is configured in SharePoint Integrated Mode and I can access the Web Service URL from the SQL/Reporting Service just fine. It displays what appears to be a directory of SharePoint sites. When I try to set Reporting Services Integration in SharePoint Central Admin I receive the following: Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages

    When I try to access the Report Server Web Service URL I'm presented with a logon dialogue, I enter credentials which I know are good, am re-prompted for credentials the presented with a blank page.

    Any advice would be appreciated.

    Thank you.

     

    Don

    Tuesday, September 14, 2010 3:32 PM
  • Hi, I too am having the same problem as MrMetry. When browsing to the reportserver location from the local report server all is working well and I can see the list of associated SharePoint Web Apps. I am NOT able to browse to this location from ANY other machines though. Kerberos is working correctly and all SPN's are associated correctly too. Any help is troubleshooting this would be great.

     

    Thanks

     

    Phil

    Monday, September 27, 2010 9:29 AM
  • Hi Phil,

    I had reproduced the issue days ago. The issue might be caused by duplicate SPNs.

    Please try to the following steps to fix the issue:

    1. Remove all the SPNs for the HTTP service for the SharePoint server and the Report Server.
    2. Reset the SPN by using the following command:
      SETSPN -r <machine name>
    3. Re-add the SPNs for the HTTP service for the SharePoint server and the Report Server.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Monday, September 27, 2010 9:47 AM
    Moderator
  • Hi Jin

    I think my issue is also related to Kerberos but can you please advice.  I can browse the report server URL on the local server http://servernam:8080/reportserver (Report Server) but when i go to a different machine (remote server), the URL page failed to open

    is that because kerberos is not working?

    Thanks\

    Swanl

     

     

     

    Tuesday, January 18, 2011 11:07 PM
  • I’ve have the same problem. try to setup SharePoint Web Front-end on a Report Server Computer as described on http://technet.microsoft.com/en-us/library/aa905869.aspx and add it to server farm. Have fixed. tips -Report server. install sharepoint 2010 and add to server farm (‘cuz problem with sharepoint object models) -report server. apply in report server config manager "web service url" and "report manager url" -report server. MS SQL 2008 services need SP2 ver.10.0.4000
    Friday, March 4, 2011 11:25 AM