We recently migrated our sharepoint from standalone to distributed environment.Everything is working fine except SSRS reports.
MOSS is on Server X and Databases,Report Server is on Database Y
Report Server is configured to run in SharePoint integrated mode.
Central Admin Settings are set as recommended by microsoft for distributed environment.
When i try to access reports or Report DataSource i get this error.
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The permissions granted to user 'EMS\bmsadmin' are insufficient for performing this
operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'EMS\bmsadmin' are insufficient for performing this operation.
I have looked around everything and all setting seems fine. Single Domain Account is used for all services and Report Server service account as well.
View Complete Post