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:
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:
Note The word "email" should be spelled "e-mail" in this error message.
Additional query words: rosetta sp1
Keywords: kberrmsg kbfix kbuser kbreport kbemail kbsqlserv2000rssp1fix KB842538