Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Troubleshoot SQL Server 2008 Report Service (step by step) Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 8:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:14 PM
Points: 4, Visits: 19
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.
Post #1465184
Posted Wednesday, June 19, 2013 8:37 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 711, Visits: 2,211
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
Post #1465215
Posted Wednesday, June 19, 2013 9:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:14 PM
Points: 4, Visits: 19
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
Post #1465261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse