Troubleshoot SQL Server 2008 Report Service (step by step)

  • Is there a step by step documentation to troubleshoot SSRS 2008? Found out SSRS is not working for a while. ASAP please and thank you in advance.

  • Hi,

    There is a log file associated with SSRS that will tell you what the problems are starting the service etc. mine is located here:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\LogFiles

    Yours will likely be located in a similar path but won't be that exact one... if you're still having trouble once you've looked at that log then post back with the errors and maybe we can help.

    Thanks,

    Simon



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • I am posting partial log with error. Let me know if you need whole file.

    Thank you in advance,

    Jyoti

    --- End of inner exception stack trace ---

    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String name)

    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.<>c__DisplayClass2.<CreateExtensionObject>b__0()

    at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)

    at System.Security.SecurityContext.runTryCode(Object userData)

    at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

    at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)

    at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)

    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig, Boolean typeOnly).

    library!ReportServer_0-4!13b8!06/19/2013-09:59:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , Could not load Authentication extension;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    library!ReportServer_0-4!13b8!06/19/2013-09:59:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , Could not load Authentication extension;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    library!ReportServer_0-4!dcc!06/19/2013-09:59:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , Could not load Authentication extension;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    library!WindowsService_29!b70!06/19/2013-09:59:32:: i INFO: Call to CleanBatch()

    library!WindowsService_29!b70!06/19/2013-09:59:32:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.

    library!WindowsService_29!b70!06/19/2013-09:59:32:: i INFO: Call to CleanBatch() ends

    library!ReportServer_0-4!8a0!06/19/2013-10:00:03:: i INFO: Catalog SQL Server Edition = Standard

    crypto!ReportServer_0-4!8a0!06/19/2013-10:00:03:: i INFO: Initializing crypto as user: CORP\CSCOM01DWREADER

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply