Hi Mahesh, Thanks for the question. Based on the detail description, I know this issue happens afther install the SQL Server 2005 sp4 package.From the error log, it seems like this issue due to some configurations had beed changed after you installed the sp4. After researched on this problem, I found that after we installed the sp4, some configurations of IIS and the report datasources might be changed, please check them. This is one similar thread, please see it for one reference: SSRS 2005 SP4 Report Services doesn't work any more after update to SP4 Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hello, I am currently facing issue with e-mail subscription in SQL Server Reporting Services 2005. I have started facing this issue after applying SQL Server 2005 SP4. My server configuration is Windows Server 2003 Standard x64 with SP2. I have SQL Server 2005 x64 Standard with latest SP4 update. I tried all the options as mentioned my Microsoft in the article http://support.microsoft.com/kb/842423 but none of the solution worked for me. I have also tried to download the hotfix KB834859 as mentioned in the article http://www.developmentnow.com/g/115_2005_4_0_0_457427/Report-Server-refuse-to-send-attachments.htm but it errored out with Mismatch Server Type. I am stuck with this issue and e-mail subscription functionality is currently down in Production. I would really appreciate, if any priority help can be available. The error that i see in reporting services log is ReportingServicesService!library!f!02/11/2012-07:15:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 1355; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. ReportingServicesService!library!f!02/11/2012-07:15:11:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!emailextension!f!02/11/2012-07:15:11:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid) at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation) at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper, String reportPath) at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials) at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification) ReportingServicesService!notification!f!02/11/2012-07:15:11:: Notification c4addde0-8fdd-4ff3-998b-5876d6d6b637 completed. Success: False, Status: Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information., DeliveryExtension: Report Server Email, Report: Customer Support - Open Tickets Summary, Attempt 0 ReportingServicesService!dbpolling!f!02/11/2012-07:15:11:: i INFO: NotificationPolling finished processing item c4addde0-8fdd-4ff3-998b-5876d6d6b637 ReportingServicesService!library!f!2/11/2012-07:15:40:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams Thanks MaheshThanks Mahesh Dhinge

Hi Mahesh, Thanks for the question. Based on the detail description, I know this issue happens afther install the SQL Server 2005 sp4 package.From the error log, it seems like this issue due to some configurations had beed changed after you installed the sp4. After researched on this problem, I found that after we installed the sp4, some configurations of IIS and the report datasources might be changed, please check them. This is one similar thread, please see it for one reference: SSRS 2005 SP4 Report Services doesn't work any more after update to SP4 Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.