An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

Answered An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

  • יום שלישי 24 אפריל 2012 06:14
     
     

    Hi All,

    I am working on epm 2007 and  ssrs 2005 sp3 in sharepoint integration mode. I am constantly having this error. I have configured ssrs (All are green and right). my report server is now working . but when i go to central admin reporting services panel..

     In central admin manage integration settings when i choose windows authentication mode that time SET SERVER DEFAULT page gives me Error .

    An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

    and when i am trying to deploy report, getting this error:

    A connection could not be made to the report server .(Microsoft Report Designer, Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services)

    I am very confused why windows authentication is not working with SET SERVER DEFAULT actually from other computer and want to get rid of these error. Please Share your knowledge for this error.


    sandeep




כל התגובות

  • יום רביעי 25 אפריל 2012 09:37
    מנחה דיון
     
     


    Hi,

    I just noticed you are using EPM 2007 and I think this should be related to Project Server. As we have specific forum for Project Server, please go to the corresponding forum for help:

    Project Server
    http://social.technet.microsoft.com/Forums/en-US/category/projectserver2010

    Thanks for your understanding and cooperation.


    Nicholas Li

    TechNet Community Support

  • יום חמישי 26 אפריל 2012 18:55
     
     תשובה

    Hi all,

       however i have managed to get reports displayed in sharepoint integration,

    i was getting error

    An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

    I just took couple of steps and it worked :

    1. Keep the trusted mode in manage integration settings.

    2. In report i kept my datasource in sql server authentication and then deployed it.(dont keep windows auth mode otherwise you will get other error while report display)


    sandeep