I am importing the organization and i didnt had any issues with permissions in SQL, SSRS and in CRM. I am local admin in all of these servers. While importing the organization its failing at publishing the reports. Please find the below error from log.
22:59:11| Info| Re-publishing reports
22:59:12| Error| Error while updating organization information: Microsoft.Crm.CrmReportingException: Unknown exception thrown by report server ---> System.Web.Services.Protocols.SoapException: The permissions granted to user 'domain\user' are insufficient
for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\user' are insufficient for performing this operation.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.Crm.ReportingServices2005.ReportingService2005.GetPolicies(String Item, Boolean& InheritParent)
at Microsoft.Crm.Reporting.SetupReportServer.AssignRole(String userGroup, String roleName, String roleDescription, String folderPath)
Any suggestions on this?
Khaja Mohiddin
http://www.dynamicsexchange.com
http://about.me/KhajaMohiddin