Hi Experts,
This is for an on-premise installation of MSCRM 2011.
We migrated the SQL and Reporting server from SQL 2008 to SQL 2012 as mentioned here.
Everything went smooth, except step 4(e).
The relevant part of the log file is pasted below:
16:11:54| Info| Updating Organization with Id=(e8aa33f0-92f8-e811-9a8a-005056990000)
16:11:54| Info| Update Organization and Users in ConfigDB...
16:11:54| Info| Update Organization in OrgDB...
16:11:54| Error| Update Organization with Id=e8aa33f0-92f8-e811-9a8a-005056990000 failed with Exception:
Microsoft.Crm.CrmReportingException: Unknown exception thrown by report server ---> System.Web.Services.Protocols.SoapException: The user or group name '****\SQLAccessGroup {5caef653-2077-4d26-9664-6623ce19d759}' is not recognized. ---> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name '*****\SQLAccessGroup {5caef653-2077-4d26-9664-6623ce19d759}' is not recognized.
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.Reporting.SetupReportServer.AddPolicy(String itemPath, Policy[] originalPolicies, String userGroup, String roleName, String roleDescription)
--- End of inner exception stack trace ---
at Microsoft.Crm.Reporting.SetupReportServer.AddPolicy(String itemPath, Policy[] originalPolicies, String userGroup, String roleName, String roleDescription)
at Microsoft.Crm.Reporting.SetupReportServer.AssignRole(String userGroup, String roleName, String roleDescription, String folderPath)
at Microsoft.Crm.Reporting.SetupReportServer.AssignRoles(String folderName, String[] publisherAccounts, String[] browserAccounts)
at Microsoft.Crm.Setup.Server.Utility.ReportsUtility.ConfigureReportsInternal(Uri reportingUrl, String organizationName, Boolean grantNetworkService)
at Microsoft.Crm.Tools.Admin.DBImportHelper.RePublishReports(IDbCommand command, Guid organizationId, String organizationUniqueName, Uri reportUrl)
at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.RePublishOrganizationReports(OrganizationData organizationData, Uri reportingUrl)
at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.Update(Guid organizationId, String friendlyName, String sqlServerName, Uri reportingUrl)
16:11:54| Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 3236.
: The user or group name '*****\SQLAccessGroup {5caef653-2077-4d26-9664-6623ce19d759}' is not recognized.