Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 8th, 2004, 09:54 PM
Registered User
 
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Service Issues Artfuldodger C++ Programming 1 July 19th, 2008 09:19 PM
connection string issues, web.config file issues kaliaparijat ASP.NET 2.0 Professional 1 June 12th, 2008 08:07 AM
Page cannot be displayed - localhost/reportserver mikehsu317 BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 6 December 8th, 2004 06:23 PM
Reporting Service Install Issues jmurdock BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 5 June 23rd, 2004 10:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.