Reporting services integration with sharepoint.

  • Hi,

    I have integrated SQL Server Reports with Windows SharePoint.

    All the reports functions was work fine in my sites before i made a change in site's admin user and password through command prompt. I tried to change the admin user, which is used to create my site, with another admin user. Both in the same domain.

    Currently i can see all the icons related to reporting services. But when i try to create data source and Manage Datasource the following error occurs.

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

    Can any one help to solve this problem? Thanks.

  • Hi

    I'm just setting up reporting services in Sharepoint Integrated mode.

    Should I be able to view the Report Manager site as you would, with a non-sharepoint integrated report server?

    Everything in the Reporting Services configuration manager seems to be ok (all icons are green, with the exception of the sharepoint one, as I haven't integrated it yet), but I can't seem to logon to the site all I just keep getting the username / password dialog box. (i have permissions though as I have domain admin level privileges and I can connect to the report server databases without any problems.)

    Any suggestions ??

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • I'm running into same issue. SharePoint 2010

    when setting up "Manage Data Sources", getting following error on all reporting service reports..

    Report Server has encountered a SharePoint error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: Exception from HRESULT: 0x80131904 ---> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904

    Correlation ID: 072af645-c886-4d88-bb8b-647604eba7ce

    Any help you can provide is greatly appreciated..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply