FIX: Subscriptions that use the e-mail delivery method for distribution may not deliver the report successfully in SQL Server 2000 Reporting Services (842538)


The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services
Bug #: 102027 (SQL Server 8.0)

SYMPTOMS

In Microsoft SQL Server 2000 Reporting Services, if you create a standard subscription that uses the e-mail delivery method to distribute a report to the users, the report may not be delivered successfully. You may notice the following error message in the Status column of the corresponding subscription in Report Manager:

Failure sending mail: The Report Server has encountered a configuration error; more details in the log files
This problem occurs when all the following conditions are true:
  • The report server database for the instance of SQL Server 2000 Reporting Services is running on a different computer. You configure your instance of Reporting Services to access the report server database that exists on a different computer.
  • The ReportServer service uses the Local System account as the service logon account.
  • You run the ReportServer service with the Local System account as the service logon account.

RESOLUTION

To resolve this problem, obtain the latest service pack for SQL Server 2000 Reporting Services. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 1.

MORE INFORMATION

In addition to the error message that is mentioned in the "Symptoms" section, you may also notice the following error messages in the trace log files of the ReportServer service:

ReportingServicesService!emailextension!cdc!05/19/2004-18:07:43:: Error sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
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)
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& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(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, JobTypeEnum 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!cdc!05/19/2004-18:07:43:: Notification 2c6db47a-e7e1-4d29-8c6d-6a713cbff871 completed.
Success: False, Status: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files, DeliveryExtension: Report Server Email, Report: Company Sales, Attempt 0
Note The word "email" should be spelled "e-mail" in this error message.
Modification Type:MajorLast Reviewed:6/22/2004
Keywords:kberrmsg kbUser kbReport kbemail kbSQLServ2000RSSP1fix kbfix KB842538 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.