Microsoft KB Archive/842538

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

Article ID: 842538

Article Last Modified on 6/22/2004

-

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 &quot;Applies to&quot; 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 &quot;Symptoms&quot; 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 &quot;email&quot; should be spelled &quot;e-mail&quot; in this error message.

Additional query words: rosetta sp1

Keywords: kberrmsg kbfix kbuser kbreport kbemail kbsqlserv2000rssp1fix KB842538

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.