Friday 24 February 2012

Conflict between BOL and README - Which one is correct?!

BOL:
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.
README-EN:
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 tried configuring the server using the SYSTEM account, however when
subscription SQL agent jobs are run I get the error listed in README 1.10.
When I reinstall the server and select a Domain Account for the ReportServer
service, I have to use a SQL account to connect. When I try this
configuration, the agent job runs and the Event table is populated, but
nothing else happens. The status shown in the Subscription is that the job
has not run. I'm at a loss. How are the accounts supposed to be configured?
Server is 2000 Advanced server with SQL 2000 Ent Ed.Hi,
I am having exactly the same problem as you report here. Did you get a
resolution to teh problem? If so please let me know!
Thanks
Laurence Neville
"Lifelongstudent" <dveit@.comcast.net> wrote in message
news:uRC9KxVZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> BOL:
> 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.
> README-EN:
> 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 tried configuring the server using the SYSTEM account, however when
> subscription SQL agent jobs are run I get the error listed in README 1.10.
> When I reinstall the server and select a Domain Account for the
ReportServer
> service, I have to use a SQL account to connect. When I try this
> configuration, the agent job runs and the Event table is populated, but
> nothing else happens. The status shown in the Subscription is that the job
> has not run. I'm at a loss. How are the accounts supposed to be
configured?
> Server is 2000 Advanced server with SQL 2000 Ent Ed.
>

No comments:

Post a Comment