ReportServer Service Issues
Wondering if anyone else has run into these issues and some of the ambiguity in the MS documentation:
For the service account, BOL states:
Microsoft recommends that you use the built-in account (NT AUTHORITY/SYSTEM) when installing Reporting Services on a Windows 2000 server. If you use a domain user account (even one that has local administrator privileges), it will limit your choices on how to configure a data source connection for a report as well as introduce new configuration steps that are not otherwise required.
In the README-EN.htm file it states:
1.10 Domain user account requirement for subscriptions and ReportServer Windows service running under Windows 2000 or Windows XP
If the ReportServer Windows service is running under Windows 2000 or Windows XP, you must configure the service to run under a domain account. If you use an account that does not have sufficient domain permissions, subscription delivery will fail when the report server attempts to deliver reports to domain user accounts. The following error occurs when report delivery fails due to authorization and domain access issues: Failure sending mail: The Report Server has encountered a configuration error.
I installed the service using the SYSTEM account and cannot successfully run subscription jobs. I get the error mentioned in the README. When I do a fresh install and chose a domain account for the service and a SQL account (can't use a Domain account for both) I can get the SQL agent job to run (agent is using a domain account as well, per MS) but the event table is updated and then nothing else happens. Checking the job status through the Reports website, the job is showing that it never ran. Any help out there? 2000 Advanced server in a domain running SQL 2000 Ent Ed and SQL Rep Svc Ent Ed SP1 (same issue without SP1)
|