web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Microsoft CRM 2011 rep...
Microsoft Dynamics CRM (Archived)

Microsoft CRM 2011 reporting service suddenly stopped working !

(0) ShareShare
ReportReport
Posted on by Community Member

Dear all,

Microsoft CRM 2011 reporting service stopped working suddenly ! means I can not create any new report and can not run existing report, it comes up with the following error message:

6204.Reporting_2D00_error.JPG

I also checked the event viewer there are some warning and error messages there:

error:

Web service request ListExtensions to Report Server crm/.../ReportService2005.asmx failed. Error: The request failed with HTTP status 503: Service Unavailable.

Warning:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/07/2015 2:21:41 PM
Event time (UTC): 9/07/2015 4:21:41 AM
Event ID: 8479cb1d7a5642dea353cf55c17e9af0
Event sequence: 282
Event occurrence: 2
Event detail code: 0

Tried to reconfigure "reporting services configuration manager" and created a new db but didn't make any difference, I uninstalled and installed "Srs dataconnector" and also reinstalled it as well without any chance !

I am using SBS2011, MSCRM 2011 & SQL 2008R2, any idea would be highly appreciated

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jharana Baliyar Singh Profile Picture
    Jharana Baliyar Singh 2,667 on at

    Hi,

    Please check below links,it might help you,

    www.linkedin.com/.../21231-216624080

    social.microsoft.com/.../crmreportingexception-the-request-failed-with-http-status-503-service-unavailable

    social.microsoft.com/.../cant-get-crm-2011-and-reporting-services-to-work

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Are you able to run the same reports using the SRS ??

    You may also  refer these links for some information

    support.microsoft.com/.../946585

    marcoamoedo.com/.../cannot-create-a-connection-to-data-source-crm

    msdn.microsoft.com/.../ms165307.aspx

    Please mark my answer as verified if you found it useful.

    Regards,

    Bhartendu Pandey

    Microsoft Dynamics CRM Support Engineer

  • Community Member Profile Picture
    Community Member on at

    I went through the Reporting Services Configuration manager and checked the urls :

    Reporting manager site url is http://crm:80/reports_CRM but I’m getting error message, HTTP Error 503. The service is unavailable.

    Report server webservice site url is http://crm/ReportServer_CRM and I am getting exactly the same error message (HTTP Error 503. The service is unavailable.) for this one as well

  • Community Member Profile Picture
    Community Member on at

    furthermore I found these 3 error messages on event viewer :

    1-Web service request ListExtensions to Report Server crm/.../ReportService2005.asmx failed. Error: The request failed with HTTP status 503: Service Unavailable.

    2-Report Server Windows Service (CRM) cannot connect to the report server database.

    3-CrmTrace encountered an error. Additional Info:Error in LoadDeploymentSettings [Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.

    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.], Stack Trace :    at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

      at System.Environment.get_StackTrace()

      at Microsoft.Crm.CrmTraceSettings.Load(String traceDirectory)

      at Microsoft.Crm.CrmTrace.get_RefreshTrace()

      at Microsoft.Crm.CrmTrace.Write(Guid orgId, TraceCategory traceCategory, TraceLevel traceLevel, Int32 skipFrames, String format, Object[] args)

      at Microsoft.Crm.CrmTrace.TraceFormat(Guid orgId, TraceCategory traceCategory, TraceLevel traceLevel, String format, Object[] args)

      at Microsoft.Crm.CrmTrace.Initialize()

      at Microsoft.Crm.Asynchronous.AsyncService.StartServiceComponents(Object state)

      at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

      at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

      at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()

      at System.Threading.ThreadPoolWorkQueue.Dispatch() (Reporting Process:CrmAsyncService, AppDomain:C:\PROGRA~1\MICROS~4\Server\bin\)

    I checked "NT AUTHORITY\NETWORK SERVICE" access right and it has "Owner", "CRMReaderRole" & "public" access rights to "MSCRM_CONFIG"  and "ORG_MSCRM" databases.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans