SSRS runnning in SharePoint Integrated mode. Permission Error on accessing reports.
Dear All
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.
Please send me any suggestions as i am unable to resolve this for the past three days.
Thanks
Dani
March 23rd, 2011 11:08pm
looks like EMS\bmsadmin does not have enough permission to run the report dirctories.
Please check here for similor error http://isolatedstorage.wordpress.com/2008/11/26/microsoft-reportingservices-diagnostics-utilities-accessdeniedexception/
http://msdn.microsoft.com/en-us/library/aa337279(SQL.90).aspx
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 11:19pm
Thanks for your quick response.
I get the same error even if access reports via Admin account which is configured as Report Server Service Account as well and is admin of everything.
March 23rd, 2011 11:43pm
Hi Dani,
This is your same thread
http://social.technet.microsoft.com/Forums/en-US/sharepointbi/thread/3ad68efa-702c-4571-80a5-af9c603eb70f
For more information Troubleshooting Configuration Problems:
http://msdn.microsoft.com/en-us/library/ms159704.aspx
Thanks,
Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 5:54am