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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics