locked
Not able to open SSRS Report in Report Builder in Sharepoint 2010 RRS feed

  • Question

  • Hello

    I am not able to open SSRS Report in Report Builder in Sharepoint 2010. What can be the reason behind this?

    Thanks

    Tuesday, November 6, 2012 2:53 PM

All replies

  • Hello Swetha,

    Please provide more information on this, what type of authentication used in SharePoint? "Anonymous Access"is one of the reason behind this. Which version of SSRS you are using? Is there any error message coming while you are trying to connect report builder from SP?

    Let us know more information on this issue


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

    Wednesday, November 7, 2012 6:15 AM
  • I am using SSRS 2008 r2 and Sharepoint 2010.

    Error - Cannot retrieve application. Authentication error.

    This error i get on sql server. If i open in native mode and go to report builder, it works fine. But if i go to report builder from Sharepoint site on Sql Server, it throws me that error.

    Thanks in advance

    Wednesday, November 7, 2012 9:11 PM
  • Thanks for the information Swetha, please try following steps as it seems the authentication is failing

    - Open Control Panel > User Accounts on SQL machine
    - Pick your Account
    - Select Manage Network Passwords
    - Retype password
    - Put in the name of the report server
    - Put in the user and password you use to login
    - Apply and OK

    Let us know your results



    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

    Thursday, November 8, 2012 6:44 AM
  • Hello Pratik

    I am in the Administrator group. I didnt understand - " Put in the name of the report server"

    Thanks

    Thursday, November 8, 2012 7:27 PM
  • Hello Pratik

    I am in the Administrator group. I didnt understand - " Put in the name of the report server"

    Thanks

    The name of the server where you have installed "SSRS". 

    Right click on My Computer > Properties and there you will find the machine name


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

    Monday, November 12, 2012 11:56 AM